Because he wants the last one in the series, not the biggest

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wjohnson" <wjohnson.1zeca1@no-mx.forums.yourdomain.com.au> wrote in message
news:wjohnson.1zeca1@no-mx.forums.yourdomain.com.au...
>
> 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
>