This one has stumped me and can't find a solution on existing threads. I am trying to count the unique names (text) across a range of cells. Specifically, I have a scheduling table of Rooms (20 rooms) vs. Days (365 days). Whenever someone reserves a room, I put his/her name in the corresponding cell. Since a person can reserve multiple rooms on multiple days, I'm trying to get an accurate read of how many unique people are making reservations. Suggestions on how to approach would be greatly appreciated!
(I'm using Mac excel 2008, but can access a PC if I need to since I know features like Pivot Tables run differently)
(I'm using Mac excel 2008, but can access a PC if I need to since I know features like Pivot Tables run differently)