Pivot tables - counting unique numbers
 

I want to "count" unique numbers using a pivot table. I enter project numbers
into a column in our job list spreadsheet. Some projects have multiple
components and each component has the same project number as the overall
project but is listed in its own row. So, within the project number column,
one project number may be listed up to 30 times. I'd like to just count the
total number of unique project numbers. I'm getting the total number of line
items in my pivot.

If it helps, the other components in my pivot table are component category
and quarter (of the year).

Thanks for any advice / tips!

Pivot tables - counting unique numbers
 

Hi

You will need to create another column in your source data to count the
uniques, then drag that column into your PT.
Supposing your items with duplicates is in column D, then in a new column
enter
=IF(COUNTIF($D$2:D2,D2)1,"",COUNTIF($D$2:D2,D2))
and copy down as required
--
Regards
Roger Govier

"christabbie" wrote in message
...
I want to "count" unique numbers using a pivot table. I enter project
numbers
into a column in our job list spreadsheet. Some projects have multiple
components and each component has the same project number as the overall
project but is listed in its own row. So, within the project number
column,
one project number may be listed up to 30 times. I'd like to just count
the
total number of unique project numbers. I'm getting the total number of
line
items in my pivot.

If it helps, the other components in my pivot table are component category
and quarter (of the year).

Thanks for any advice / tips!

__________ Information from ESET Smart Security, version of virus
signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Pivot tables - counting unique numbers
 

The formula worked like a dream. Thank you for your quick response.



"Roger Govier" wrote:

Hi

You will need to create another column in your source data to count the
uniques, then drag that column into your PT.
Supposing your items with duplicates is in column D, then in a new column
enter
=IF(COUNTIF($D$2:D2,D2)1,"",COUNTIF($D$2:D2,D2))
and copy down as required
--
Regards
Roger Govier

"christabbie" wrote in message
...
I want to "count" unique numbers using a pivot table. I enter project
numbers
into a column in our job list spreadsheet. Some projects have multiple
components and each component has the same project number as the overall
project but is listed in its own row. So, within the project number
column,
one project number may be listed up to 30 times. I'd like to just count
the
total number of unique project numbers. I'm getting the total number of
line
items in my pivot.

If it helps, the other components in my pivot table are component category
and quarter (of the year).

Thanks for any advice / tips!

__________ Information from ESET Smart Security, version of virus
signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4533 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com



.