COUNTIF - is this the solution to my problem?
Posted by Lynnsey on February 04, 2002 3:59 AM
I am trying to do the following:
I have a list of guests on one worksheet. One of the columns is the guest's name and another column is the table number that the guest has been assigned to. On another worksheet I have the table numbers in a row across the screen and I would like the names of the guests assigned to those tables to appear below. I *think* I need to use COUNTIF but I haven't been able to figure out how - any help would be appreciated.