Finding the maxium value of a column

[feman007]

Hi,
Is there a way to find the maximum value of a column in Excel and then list
it along with the corresponding values in adjacent cells in the row? I know
it can be done with simply sorting the data but I was hoping to do it without
rearranging the data.
Thanks,
feman007

 

[Bernard Liengme]

For Max: =MAX(B:B)
For cell next to it: =INDEX(A:A,MATCH(MAX(B:B),B:B))

In both cases B:B (etc) can be replaced by range such as B3:B233


best wishes

 

[Aladin Akyurek]

http://tinyurl.com/4rox2

which also picks up the ties of the max value.

 

[Harlan Grove]

For cell next to it: =INDEX(A:A,MATCH(MAX(B:B),B:B))

....

Requires that col B be sorted in ascending order. If that doesn't apply, use

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

 

[feman007]

Thanks to everyone for all the help. I got it to work.

 

[feman007]

Thanks to everyone for all the help. I got it to work.