View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Haack Steve Haack is offline
external usenet poster
 
Posts: 44
Default Question using LARGE=

Let's say I have 10 worksheets which have the results of 10 games (or
competitions). On a summary sheet, I want to find the 5 largest scores from
the competitions. LARGE assumes that the array I want to search is contiguous
(all on the same sheet). Is there a way to tell it to look at each of the 10
sheets and find the 5 largest scores? Perhaps its just a syntax thing and I'm
just not sure who to indicate what I need.

Thanks,
Steve