Finding the maxium value of a column
 

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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"feman007" wrote in message
...
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

http://tinyurl.com/4rox2

which also picks up the ties of the max value.

feman007 wrote:
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" wrote...
....
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))

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

"Aladin Akyurek" wrote:

http://tinyurl.com/4rox2

which also picks up the ties of the max value.

feman007 wrote:
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

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

"Aladin Akyurek" wrote:

http://tinyurl.com/4rox2

which also picks up the ties of the max value.

feman007 wrote:
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