Thread: Search function in a Pivot Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HL Questions HL Questions is offline
external usenet poster
  
Posts: 4
Default Search function in a Pivot Table
How would I write the function in an Inserted Calculated field to a Pivot
Report to search Field1 for "Prospects", if present, insert amount from
Field2, if not, return 0?
Reply With QuoteReply With Quote