find largest value cell acrss worksheets
 

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.

find largest value cell acrss worksheets
 

=MAX(Sheet2:Sheet30!A1)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"charlene" wrote in message
...
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.

find largest value cell acrss worksheets
 

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

That's a start, but the OP asked

"charlene" wrote in message
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.

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))