I need a function to calculate all the 'unique' dates infront of each account. Thanks!
I looked at the file in detail now - but it's not solving the problem.
The pivot table is only showing the 'count' of dates.
I'm looking for the 'count' of unique dates.
So for example 10th avenue gourmet should only show '1' because there's only one date - which 6/17/2013
Thanks a lot of all the help again.
We're on the right track - but still haven't got the answer I'm looking for.
For example, I want the answer to be in the PIVOT or as a function in the pivot source - so it can be dynamic - and it will update automatically everytime I refresh the data, or change the sort of the pivot.
Also - It's still not showing me the actual the number of dates per store as a total.
Ideally, I'd like one column to display the total number of unique dates.
10th ave gourmet 1
Astor Row cafe 2
Fairway Douglaston 4
Jess - you're the best!
I've been trying to solve this problem for daaaaays!
That's exactly what I was looking for!!!
No doubt I'll have many more questions to come as I build this spreadsheet.
Anychance you can explain the logic behind the =IFSUMPRODUCT function you put in?