I am trying to find a formula that will look at a list of team names and
returns how often a particular team is in the list.
What i am exactly trying to do is this. I have 16 teams in a sports
tournament and each has to vote for their 1st 2nd & 3rd choice of most
spirited team, and i am going to do this with combo boxes, and the
results will be in a table with the column headings. Team, 1st choice,
2nd choice, 3rd choice. So what i want to do is look down each list in
turn and tell me how often a particular team has been selected. For
example if i had the list

Spades
Hearts
Spades
Diamonds

so i would want a return of 2 when querying about spades and a return
of 1 when querying about hearts, and diamonds, and a return of 0 when
querying about clubs.

Anybody got any ideas

Sorry bout the long windedness


--
pouch
------------------------------------------------------------------------
pouch's Profile: http://www.excelforum.com/member.php...o&userid=36695
View this thread: http://www.excelforum.com/showthread...hreadid=564248