| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return worksheet name containing value found in 3D reference funct
I'm trying to write a function that returns the worksheet name of a max value
in a simple 3d reference. Sheets 1 through 8 hold values in cell C1. In a summary page =MAX(Sheet1:Sheet8!C1) returns the max value found in any of those cells. Can a function return the sheet name of the sheet on which that max value was found? Additionally, what errors might be generated if the Max value is on more than one sheet? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup, return zero if not found | Excel Worksheet Functions | |||
| can lookup return err if no match found | Excel Worksheet Functions | |||
| Linear interpolation between two points found using a lookup funct | Excel Worksheet Functions | |||
| How do you reference another cell in the criteria of a SUMIF funct | Excel Worksheet Functions | |||
| A function to get a variable row reference for range in XNPV funct | Excel Worksheet Functions | |||
Threaded Mode
