| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a row with a maximum value array?
Does anyone know how to reference the row number that a maximum value appears
in. I don't want to reference the value but the actual row. Here is what I am putting in but it is now correct =row(max(column_array) Where the column array would be; D4:D10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum number of elements in array | Excel Discussion (Misc queries) | |||
| Finding Maximum of Two Numbers in Array | Excel Programming | |||
| Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
| Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
| Can you identify the maximum value in an array? | Excel Programming | |||
Threaded Mode
