=SMALL($A$1:$E$1,COLUMN(A1))

and copy across

--

HTH

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


"jwebb" wrote in message
...
I have a range of numbers that span from A1-E1. I would
like for F1 to show the lowest number in the span (min),
G1 to show the 2nd lowest number, H1 to show the 3rd
lowest, etc.

TFTH,
Jay