find largest value cell acrss worksheets

C

charlene

how can I find the worksheet that contain the largest value cell cross all
the worksheet of the same workbook?the cell address is the same in all
worksheet.
 
H

Harlan Grove

Peo Sjoblom wrote...
=MAX(Sheet2:Sheet30!A1)
Click to expand...
....

That's a start, but the OP asked

which looks like the OP wants the worksheet name rather than the
largest value. If so, easiest to use an ordered list of worksheet
names, perhaps named WSL, and a formula like

=INDEX(WSL,MATCH(MAX(N(INDIRECT("'"&WSL&"'!A1"))),
N(INDIRECT("'"&WSL&"'!A1")),0))
 
Top