Just use Count as your summary function. The specific steps will depend on
which version of Excel you have. Post back if you need more help.

Regards,
Fred.

"Susienak" wrote in message
...
I have a list that contains numbers that repeat Example: 900,825,827,900,
765,827,765, 765, 902, 900, etc... I want to know how many times each
number
is repeated in that column. I was told Pivot table can do thsi easily so
that if I have 100,000 numbers and 400 of them are unique it can tell me
how
many times each unique number shows up ( I dont want to add the numbers
together as in 900 + 900 + 900 = 2700 but rather I want to see 900 = 3
times
repeated). There are
thousands of numbers repeated thousands of times so I cant have one
formula
that I have to put in for each number. I need one formula period that will
open a column that shows all the repeats. Can someone explain this step by
step in a Pivot Table
because Im new to Excel...

Thanks,

Susan