I have a spreadsheet that looks like this on Google Drive:
Further down the page, I do a count of everyone who matches a specific date (which is dynamically updated), and I want to LIST out the names of all the people registered for that date.
So, basically, the formula scans the entire D column, checking to see if any values match C127, and if so, it makes a list of the A values of those matching columns, ideally comma separated, like "Name 1, Name 2, Name 3" - there should be 6 names in total.