Return Numeric Labels that have Values >=4 across Single Row

[Sam via OfficeKB.com]

Hi All,

Happy New Year.

I have two columns of data: Column "A" = Numeric Labels and Column "B" =
Numeric Values; rows 17 to 100.

I would like a Formula to return across a single row in ascending order
Numeric Labels that have Numeric Values >=4 (greater than or equal to 4).


Sample Data:
Col "A" Col "B"
Labels Values

146 7
131 6
120 6
142 5
105 4
104 4
149 3
140 3
124 3
122 3
etc

Expected Results:
Labels with numeric values of 4 or more Returned across a single row in
ascending order.
104, 105, 120, 131, 142, 146


Thanks,
Sam

 

[T. Valko]

Array entered:

=IF(COLUMNS($A:A)<=COUNTIF($B17:$B100,">=4"),SMALL(IF($B17:$B100>=4,$A17:$A100),COLUMNS($A:A)),"")

Copy across.

Biff

 

[Sam via OfficeKB.com]

Hi Biff,

Thank you very much. That certainly did the job. Great!

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Hi Biff,

Thank you very much. That certainly did the job. Great!