N

#### Novice

particular value?

e.g.

A B

1 1 Text A

2 1 Text B

3 2 Text C

4 3 Text C

5 4 Text C

4 Text C

I would like the formula to find all instances of the value 1 (one) in

Column A and then concatenate only those Rows in Column B

result: Text A; Text B

I will need to repeat this exercise for 40 particular values.

I cannot use macros, addons, or VBA editor.