Is there some magical combination of functions that allows one to search a table of values and return a list of values?
My table has dates across the top row, and names down the side. Within the table are Y, N, or blank. I want to get the list of names based on the Y's in a particular column (which corresponds to a date). Oct 4 Oct 6 Oct 8 Oct 9 Mark Y Y Sam Y Y Frank Y N Y Henry Y Y Y Y Searching for Oct 4 returns the string "Mark, Frank, Henry". Searching on Oct 6 return the string "Sam, Henry". The list of names can not be placed in alphabetical order. I could probably use a macro, if I knew how to use macros....;-) I would rather just have a formula, but perhaps that is not possible? Thanks, Mark