I know this cannot be done with formulas, and I am not even sure it can be done with VBA. I am trying to figure out a way to create an alphabetic list with a schedule of when/where names occur in a schedule. Row 1 includes the location and Column A has the times. I need an alphabetic list of when and where names occur (what time and what location).
I have attached a sample of what a schedule looks like. Basically, what I would like is to be able to create a report that says something like:
Bronze - 8:00/Court 2, 9:00/Court 2, 11:00/Court 1, 12:0/Court 1
Copper - 8:00/Court 1, 10:00/Court 2, 11:00/Court 2, 1:00/Court 1
Any help in figuring this out would be greatly appreciated. Or, if it is not possible, that would be good to know so I can move on to other ideas.