| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get this
I'm trying to find a function that find the max. value in one column but
return the corrosponding value from a different column though in the same row. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I get this
=index(a1:a10,match(max(b1:b10),b1:b10,0))
Mutaz wrote: I'm trying to find a function that find the max. value in one column but return the corrosponding value from a different column though in the same row. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
