Formula Hlelp Sort Range Between 2 Values

[ststern45]

Hello everyone,

I have a range of values in cell range W20:BF20

In cell BR20 I would like to list all the values from W20:BF20 where the values range from 100 through 199.

Also sort the list from small to large values.

Cell range W20:BF20 does contain empty cells.

Values in range W20:BF20 min = 100 max = 999

Thank you in advance!!

 

[Eric W]

Put this in BR20 and drag down:

=IFERROR(AGGREGATE(15,6,$W$20:$BF$20/(($W$20:$BF$20>=100)*($W$20:$BF$20<=199)),ROWS($BR$20:$BR20)),"")


If you want all the values in a single cell, that will require either VBA or the TEXTJOIN function. Do you have that?

 

[ststern45]

Thanks Eric.
Works great!!

I don't need a TEXTJOIN function.

Thanks

 

[Eric W]

Great! Glad it works for you.