Array Function to Return Name of Largest Value in a Range

[ClaytonKershaw]

I'm working on an array formula to return the name of the value with the largest value in a range.

In column A, I have the cities names and in column B I have the pouplations that correspond to the city name.

I can do an if formula such as =IF(B3=MAX($B$2:$B$44),A3,"") and that will provide the name of the largest value. However, I have to fill handle it down the entire range. Thus why I am trying to create an array so I can just enter it in one cell.

Thanks




[TABLE="width: 155"]
<TBODY>[TR]
[TD][/TD]
[TD]
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Jonmo1]

welcome to the board...

Try

=INDEX($A$2:$A$44,MATCH(MAX($B$2:$B$44),$B$2:$B$44,0))


Note, if there are 2 or more of the same MAX value, it will return the value from the top one.

 

[ClaytonKershaw]

welcome to the board...

Try

=INDEX($A$2:$A$44,MATCH(MAX($B$2:$B$44),$B$2:$B$44,0))


Note, if there are 2 or more of the same MAX value, it will return the value from the top one.

Thant worked! Thank you very much!

 

[Jonmo1]

Glad to help, thanks for the feedback.