How do I tally the number of times a random number occurs

[Puckrazy]

I created an excel workbook to simulate drawing name out of a hat by using a random number generator that looks up the number generated and displays a name each time i refresh the worksheet. I was hoping to create a formula that tabulates how many times a name (number in my random number range) has been generated and totals the number or drawings.

Basically want to create a formula that iterates by adding 1 to the appropriate tally each time it draws a name/number, and sums the number or "drawings".

Occurrences
1 MARY 5
1 Random Number 2 CATHY 4
3 TOM 8
4 JANET 9
5 NANCY 7
6 ANN 5
7 STEVE 5
8 BETH 4
9 JAMES 8
10 MARK 8
11 AMY 9
72 Total Drawings
WINNER: MARY

[davesexcel]

Try this

Please Login or Register  to view this content.

[Sintek]

Another option...

Please Login or Register  to view this content.