CODEWITHSUNDEEP
excelexcel-formula
user1342645
user1342645

Reputation: 655

Concatenate range in Excel with formulas

I am looking for a way to concatenate an unbounded range of cells containing text with formulas. I have done some research and it looks like it is not possible but, I was thinking that maybe using circular reference it would be possible and I have not seen anyone tried before or commenting about it, and I tried myself but did not work.

The idea is the following. I have this data:

enter image description here

I want to not have into account the number of rows I have so let's call it x rows. X rows should change dinamically by adding a new letter and a new number

Then I want the list of letters whose values, for example, are less than 3.

Upvotes: 1

Views: 749

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

In C1 enter:

=IF(B1<3,A1,"")

and in C2 enter:

=IF(AND(B2<3,B2<>""),C1 & A2,C1)

and copy down. Your answer will be the last value in column C:

enter image description here

Upvotes: 1

Related Questions