word frequency

P

pouch

I am trying to find a formula that will look at a list of team names an
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 sport
tournament and each has to vote for their 1st 2nd & 3rd choice of mos
spirited team, and i am going to do this with combo boxes, and th
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 i
turn and tell me how often a particular team has been selected. Fo
example if i had the list

Spades
Hearts
Spades
Diamonds

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

Anybody got any ideas

Sorry bout the long windednes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping integers to strings 6
I've never seen this symbol before 4
Missing Symbols 9
Diamond symbol in MS Word 1
Can't use "Diamond" in VBA, can't program a replace... 1
CHOOSE function, is this impossible? 2
using an IF or AND function to get next largest value in list 1
list items from one table in another table based on value in first table 2

Top