| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Max from Variable Range
I have the following spreadsheet and want to find the maximum number in a
variable range based on the value of a cell - 3 rows. A1 B1 45 7 66 43 22 11 22 In the above data I would like to find the max of A4:A7 because 7 is entered into the cell of A3B3 (7 - 3). The value of A3B3 will change so the range I need to have max of will change also. Thanks in advance - Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells.Find with a variable | Excel Discussion (Misc queries) | |||
| Right Text - Variable Find | Excel Discussion (Misc queries) | |||
| find a variable text string | Excel Discussion (Misc queries) | |||
| 3 variable find and replace | Excel Discussion (Misc queries) | |||
| How do I find the last row of data and then use that as a variable | New Users to Excel | |||
Threaded Mode
