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