Filter by column

+2

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.

+1

Hello,

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

+2

Yes, they are linked.

+1

Yes, they are linked.

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?

Sign up