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