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

J

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
 
B

Bob Phillips

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

and copy across

--

HTH

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

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!
==============================================


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
 
Top