View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DHN DHN is offline
external usenet poster
 
Posts: 1
Default Pivot Table (behind the scene)

Hello MVPs,

I need help with a formula that would be able to do the same as a filter in
a pivot table. I have two filters that I would like to be able to do. The
reason why I can not use a pivot table is because I have data on multiple
tabs within the workbook.

If I am not clear with the issue please let me know. Thanks.

Dai