hi :)

ok here's my question. i have 4 columns (A:D). for each row, i need the
5th cell to say which is the highest. lets say a-d are apples, oranges,
bananas, pears. and the spread looked like this:

A O B P
5 7 3 5
1 8 2 4
1 0 6 4
8 2 6 3

i would want to add a 5th column that figures out which of A-D is
highest and tells me. so it would look like this:

A O B P Max
5 7 3 5 Oranges
1 8 2 4 Oranges
1 0 6 4 Bananas
8 2 6 3 Apples

i'm not worried about ties (they will be very rare) so you can have an
error or give the wrong answer, whatever.

thanks very much for your help :)


--
j0e
------------------------------------------------------------------------
j0e's Profile: http://www.excelforum.com/member.php...o&userid=28552
View this thread: http://www.excelforum.com/showthread...hreadid=482105