Thread: Multiple Lookups with some Calculations and Sum Frequencies
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Multiple Lookups with some Calculations and Sum Frequencies
"Discrete Lot" count can be easily added
to the Pivot Table.
To show just "1" in the "Pass" field,
just click on the arrow and select "1".
http://www.freefilehosting.net/download/3aeaj
Reply With QuoteReply With Quote