Pivot tables - counting unique numbers

C

christabbie

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!
 
R

Roger Govier

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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top