Thread: Looking for pivot table functionality that shows detail instead of count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Looking for pivot table functionality that shows detail instead of count
Here is a solution for multiple counts in a cell.
Assign a prime number to each ChildName (starting with 3)
and use Product of ChildName.
Then find the prime factors of the resulting Pivot Table product.
For how to generate primes and find factors, search
excel.worksheet.functions
"How to find prime factors of a number"
Nov 29, 2005
Lookup factors to get names and concatenate them.

Reply With QuoteReply With Quote