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
[email protected]
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.
 
Top