Thread: Search multiple sheets and return largest number found
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
  
Posts: 340
Default Search multiple sheets and return largest number found
=LARGE('Sheet1:Sheet40'!A:C,1)
=LARGE('Sheet1:Sheet40'!A:C,2)
=LARGE('Sheet1:Sheet40'!A:C,3)

mpenkala wrote:
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