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