Why not use the "Large" function
the following example checks for the "largest" value in a selection:
=LARGE(B4 D4,1)
Put a "colon" between B4 and D4 - no spaces. I get a "smiley face" if I
use a colon.
This would be for column B thru D in row 4. The "1" is the for the
largest if you wanted the
second largest use a 2. Excel has a good help info on this function


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2297300