Hi,
I have a Sign-Up sheet for Tennis Players for a single day. There are lots of courts to assign them to and times they want to play. I need to pull up the first time on each court (by the court name) and list the 4 players assigned to play at that time. I'm sure this is some Offset Match combination. The first players of the day might be found using
Match("*",Column,0). I'd like all the calculations based off the Court Name. See the attached.
I find some days are "dumb days" for me and nothing works. Other days nothing fails. I'm on a dumb day...
Also - these guys are stuck in 2003 Excel so no Countifs or IfError ... Sorry.
Bookmarks