How to use pivot table to count repeats of unique fields
 

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

How to use pivot table to count repeats of unique fields
 

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

How to use pivot table to count repeats of unique fields
 

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


Replace @mailinator.com with @tiscali.co.uk


"Fred Smith" wrote in message
...
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

How to use pivot table to count repeats of unique fields
 

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" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"Fred Smith" wrote in message
...
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

How to use pivot table to count repeats of unique fields
 

"Fred Smith" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"Fred Smith" wrote in message
...
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" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"Fred Smith" wrote in message
...
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