put content of adjacent cell (comma-separated) into cell if value is higher than x

[vreni]

Hi there,

I am an absolute VBA newbie and need help:

I have a list of values in cell A and in B a list of verbs.
I want to put all verbs which have a values higher than 3 in a separate cell and make excel separate them with a comma, semi-colon or the sorts.

Any pointers would be very much appreciated!
Thanks a lot

 

[mikerickson]

Try
=ConcatIfs($B8:$B1504, $H8:$H1504, ">2", $H8:$H1504, "<3", ",")

 

[vreni]

Excellent, that worked! Thank so much!!! It is such a relief not to have to do this manually!!!