I have a football listing of players in Col A and dates on rows along the top. Each player has to assign a Y or a N on their named row to suggest whether or not they are able to attend that day.
Currently I have a macro (courtesy of John Davis) that returns the dates that everyone can do. I want to amend this macro slightly though on the basis that if not everybody can attend (ie at least one person says N) then the macro will return the dates where the majority of people can come, and return the names of the players that are missing.
See attachment for what I have so far (B17:C19 are my expected results. If you change anything in the Y and N ranges these expected results will be cleared, just so you know.)
Bookmarks