| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
Hybrid Mode
