View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
LawrenceHG LawrenceHG is offline
external usenet poster
 
Posts: 3
Default 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