count unique dates in pivot

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I have a pivot and I need it to count the number of unique values. Is this
possible in a pivot?
 
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
 
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.
 
You must log in or register to reply here.

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
Turning Data into a Table 1
Pivot table calculated field Count(field) / sum(field) 0
Pivot Tabel Question. 7
Excel 2007: Formula to count unique values in a range 11
PIVOT TABLE - Show Dates in months 3
Pivot table report invalid 0

Back
Top