Hi,

I have a spreadsheet with two tabs. On the first tab is a list of event dates in column E and the groups invited to those events in column D. So it might say that an event on one date was attended by group1, group3, group7, while the row below shows an event on the following day attended by group3, group 4, group6. On the second tab is the full list of groups.

What I need is a formula on the second tab that will return all the dates attended by each group, either in one cell separated by commas or in consecutive cells in that row.

So far I've developed this formula for the second tab:
=IF(ISNUMBER(SEARCH($C2,'Tab1'!$D4)),'Tab1'!$E4,"")

The problem is that this just delivers the first date of attendance without also providing the later dates.

Any suggestions?