Thread: Search multiple sheets and return largest number found
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mpenkala mpenkala is offline
external usenet poster
  
Posts: 90
Default Search multiple sheets and return largest number found
Hey gang,

I have a workbook with about 40 worksheets in it. Each sheet contains
multiple scores for an individual. I would like to be able to search every
worksheet and return the 3 largest scores found.

Any ideas?
Thanks,
Matt

Reply With QuoteReply With Quote