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

  • Thread starter Sam via OfficeKB.com
  • Start date
S

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Matched Numeric Labels across Single Row 4
Return Numeric Labels that have different Numeric Values 8
Return Unique Duplicate Numeric Values across Single Row 7
Return Matched Numeric Values across Rows 2
Match Multiple Criteria & Return Numeric Labels across single row 8
Return Unique Consecutive Duplicate Values across Single Row 22
Find and Return Numeric Label based on (Numeric Value) Criterion 2
return multiple values when within range (greater than and less than) 11

Top