List all values found within a range.

To list all the values in one row try this formula in H4

=IF(COLUMNS($H4:H4)>SUM(($B2:$B46>=1)*($B2:$B46<=5)),"",INDEX($A2:$A46,SMALL(IF(($B2:$B46>=1)*($B2:$B46<=5),ROW(B2:B46)-ROW(B2)+1),COLUMNS($H4:H4))))

This is an array formula which needs to be confirmed with CTRL+SHIFT+ENTER. To do this, paste formula in to H4, select that cell and press F2 key. Now hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula in the formula bar

Now copy formula across, once you run out of matches you just get blank cells

Hi Daddylonglegs,

Thanks for the quick reply! Your formula works perfectly.

That is exactly what I wanted. Thanks for your help!

I really appreciate your helps.

Cheers.


Best Regards,

Eric