Thread: Return multiple values using a lookup function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Return multiple values using a lookup function
Excel 2007 Pivot Table
Most terrifying formula (of 2):
=COUNTIF(Table2[Cust],Table1[[#This Row],[Cust]])
No limit on reps, no copy/paste/fill.
Dynamic Tables.
http://www.mediafire.com/file/wgxmyz...03_18_09a.xlsx
Reply With QuoteReply With Quote