Return Numeric Labels that have Values =4 across Single Row
 

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

--
Message posted via http://www.officekb.com

Return Numeric Labels that have Values =4 across Single Row
 

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" <u4102@uwe wrote in message
news:6ba8a7a3e8e5a@uwe...
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

--
Message posted via http://www.officekb.com

Return Numeric Labels that have Values =4 across Single Row
 

Hi Biff,

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

T. Valko wrote:
Array entered:

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

Copy across.

Biff

--
Message posted via http://www.officekb.com

Return Numeric Labels that have Values =4 across Single Row
 

You're welcome. Thanks for the feedback!

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:6baf90837e08f@uwe...
Hi Biff,

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

T. Valko wrote:
Array entered:

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

Copy across.

Biff

--
Message posted via http://www.officekb.com