Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc

[jwebb]

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

[Bob Phillips]

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

and copy across

--

HTH

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


"jwebb" <anonymous@discussions.microsoft.com> wrote in message
news:5df701c524a3$1a6764e0$a601280a@phx.gbl...
> 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

[RagDyeR]

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" <anonymous@discussions.microsoft.com> wrote in message
news:5df701c524a3$1a6764e0$a601280a@phx.gbl...
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