ExcelBanter - how do I get this

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I get this (https://www.excelbanter.com/excel-worksheet-functions/56364-how-do-i-get.html)

Mutaz

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.

Dave Peterson

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

All times are GMT +1. The time now is 05:48 AM.