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

=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

Enter this in F1, and drag across to copy:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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