Why not use the "Large" function
the following example checks for the "largest" value in a selection:
=LARGE(B4:D4,1)
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