You can run LARGE over several sheets:

=LARGE(Sheet1:Sheet3!A1:C1,1)

will look at A1 thru C1 on sheets 1,2,3 and return the largest value
--
Gary''s Student - gsnu200826


"Steve Haack" wrote:

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