Value next to Max Value in Column

[mahendragaur]

Hello All,

I want to get the Value from next column to max value of any column. fox example max value is "663457" in column 'A' and it's row no. is "136". So,  I want value from column 'B' of row no. '136'

[tresesco]

Try using FirstSortedValue()

[MindaugasBacius]

Upload the sample data.

[mahendragaur]

I don't want to get the value from the same column. I want value from neighbor column if max value is found in column A.

for example- max value is "663457" in column 'A' and it's row no. is "136". So, I want value from column 'B' of row no. '136'

[tresesco]

Did you try the function - firstsortedvalue(), I suggested above? If using the same function, you can't get the result, try to share a sample app to get more specific help.

[mahendragaur]

Below is the table I have. I need to show the Name 'c' in a variable because it has the max Value i.e. '6'

Name Value
a 3
b 5
c 6
d 1

[tresesco · Accepted solution]

=FirstSortedValue(Name, -Value)                         // note '-' sign