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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a row with a maximum value array?
=MATCH(MAX(D4:D10),D4:D10,0)+3
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pete" wrote in message ... 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 |
Reply |
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 |