A Pivot Table challenge--I can't do it, can you?
Roger--
All hail thee king of the MVPs! It works.
Very clever...I've seen this type of formula before, but I hadn't added it
to my bag of tricks...perhaps now I will.
I'm having trouble getting it to work on all 19,000 rows...the calculation
time is immense, but I verified it on a subset of the data.
Thanks for your help. I've really learned something good.
"Roger Govier" wrote:
Hi Lawrence
You will need to add another column to your source table Named Count
In D2 enter
=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=$B2)*($C$2: $C2=C2))=1,1,0)
and copy down
Add the Count Column to the source range for your PT, and use Sum of Count
as your data field
--
Regards
Roger Govier
|