count unique dates in pivot

I

Ian

I have a pivot and I need it to count the number of unique values. Is this
possible in a pivot?
 
N

Nick Hodge

Ian

If these are set as a row field it will only show the unique dates, you
could COUNTA the total rows or just see where they end up and deduct from
where they start

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
 
H

Herbert Seidenberg

Add a column next to your original Dates column,
named CountD and enter this array formula:
=1/COUNTIF(Dates,Dates)
Include CountD in your PT as Sum of CountD
The Grand Total for Columns in your PT will show
the number of unique Dates in ROW.
 

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

Similar Threads

How to show a count of Unique IDs in a Pivot Table 2
Pivot Tables - Unique items 2
PIVOT TABLE - Show Dates in months 3
Turning Data into a Table 1
Pivot table calculated field Count(field) / sum(field) 0
Excel 2007: Formula to count unique values in a range 11
pivot table calculated field 1
Possible to use pivot table on non-mumeric fact data withoutcalculating? 3

Top