I'm hoping you guys can help me out again, youve been great in the past..
I have a spreadsheet with a list of hundreds of names (in one column), and their position (in another column). What I need to do, is count the number of instances each name appears in the spreadsheet, while at the same time, excluding 9 specific names that all have the same position. So for example,
Name / Position
A 1
B 2
C 3
D 4
A 1
E 4
F 5
A 1
B 2
So lets say the position I want to exclude is position #4
The outcome I would like is:
Name / Number of Times Appeared
A 3
B 2
C 1
F 1
Any help would be really appreciated...
thx!
Bookmarks