Apologies. I'm new to the site and didn't realize that you had asked additional questions.
So when I select the date in Column A
... You could use basic filter to select any text from A-column.
Did You skip my How -questions? - Not seeing the how questions.
Because above ... You could use conditional formatting to show those who has selected...
Does that make sense?
... does that make sense?
Kind of. So there are multiple games on any given date, but say on November 1 Cavs vs Hornets will yield one winner. So for any row, I need those that selected column e from columns F- how many ever. I may need to write everyone's picks somewhere else, but essentially. I want to be able to select a game day, and see who the winners are from that game day.
I'm tracking all of the winners for an ultimate winner at the end of the season (total wins correctly picked), and I would like a macro that for any day I select, I can get a list of all of those that chose the winner.