Excel Formula Question

[ststern45]

Hello everyone,

I have a range of cells A1:F1 with the following values:
A1 = 667
B1 = 577
C1 = 568
D1 = 467
E1 = 557
F1 = 566

There are 4 values between 500 and 599. 577, 568, 557, 566
Cell G1 I have the value 500 which indicates any values of 500 through 599
Cell range I1. If countif values in cell range A1:F1 are between 500 and 599 enter the 1st value in cell I1 starting with the smallest of the 500 through 599 values from A1 through F1.
So cell range I1 through L1:
I1 = 557
J1 = 566
K1 = 568
L1 = 577

Thank you in advance!!

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	667	577	568	467	557	566	500	557	566	568	577
Data

Cell Formulas
Range	Formula
H1:M1	H1	=IFERROR(AGGREGATE(15,6,$A$1:$F$1/($A$1:$F$1>=$G$1)/($A$1:$F$1<=$G$1+99),COLUMNS($H1:H1)),"")

 

[ststern45]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	667	577	568	467	557	566	500	557	566	568	577
Data

Cell Formulas
Range	Formula
H1:M1	H1	=IFERROR(AGGREGATE(15,6,$A$1:$F$1/($A$1:$F$1>=$G$1)/($A$1:$F$1<=$G$1+99),COLUMNS($H1:H1)),"")

Excellent work Fluff. Works great. Exactly what I was looking for.
Stay Safe!!

 

[Fluff]

You're welcome & thanks for the feedback.