How to use pivot table to count repeats of unique fields

[Susienak]

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

 

[Fred Smith]

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.

 

[Sandy Mann]

I think that Fed may have meant COUNTIF() rather than COUNT()

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Fred Smith]

I meant use the count facility in the Pivot Table.

Sandy's idea of using Countif is an alternative to a pivot table.

Regards,
Fred.

 

[Sandy Mann]

I meant use the count facility in the Pivot Table.

Yer, Sandy would get on a lot better if he learned to read! <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk