How to use pivot table to count repeats of unique fields

  • Thread starter Thread starter Susienak
  • Start date Start date
S

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
 
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.
 
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
 
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.
 
Fred Smith said:
I meant use the count facility in the Pivot Table.
Click to expand...

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
 
Back
Top