Thanks folks! Have a great day!
"doucetrr" wrote:
you can use the Max function to achieve this too, which is easier to
implement/maintain than the "If" function. For example, let's say
columns E through H have numbers and you want to select the highest
number from the four columns. You would use the following formula:
=MAX(E2:H2).
--
doucetrr
------------------------------------------------------------------------
doucetrr's Profile: http://www.excelforum.com/member.php...o&userid=24872
View this thread: http://www.excelforum.com/showthread...hreadid=384149