| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MAX across worksheet, return text value
Hi, need some help.
I have 20 worksheets, with an additional sheet as the 'Summary' page. I have a formula in cell A2 which returns the MAX value of the same cell in 20 worksheets (sandwiched between 'dummy' worksheets titled 'Start' and 'End'). Formula is =MAX(Start:End!$N$1) The value returned will always be a numerical. For the cell (B2) in 'Summary', i would like it to display the text of cell AA in the 20 worksheets which matches the MAX value returned. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link to text and return text into a formula? | Excel Worksheet Functions | |||
| LOOKUP text return text | Excel Worksheet Functions | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
| I need to return the name of a worksheet in another worksheet cell? | Excel Worksheet Functions | |||
| Match text to another worksheet and return a certain value | Excel Worksheet Functions | |||
Threaded Mode
