Filter by column

[ondratyle]

Hello,

I have Table of people and for eveybody I have registration month by number. 

It looks like that: Name:Adam, Registered:9

Than I have second table with courses. For each course I have assigned that people. The cource has its own month.

For example: Yoga:Adam,Robert, Month:9

I would like to have new column, that will include only the people that was registered in the same month as the course.

The month is different for each course so I cannot use the filter function in rollup. Please help.

[AmandaWhiting]

Hello,

Are the people you have assigned in Table 2 records linked or just names? 

[ondratyle]

Yes, they are linked.

[AmandaWhiting]

 

I've had this same issue in the past so I made a mock table. Is this what you would want your 2 tables to look like?