1

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.

halfer
  • 19,824
  • 17
  • 99
  • 186
user1342645
  • 655
  • 3
  • 8
  • 13
  • What are you trying to do? What do you expect the formula to return? I You want to concatenate cells B&C, only if C is greater than 3? What's column E doing? – BruceWayne Jan 22 '16 at 17:27
  • Don't believe there's a way to do this in a single cell - I tried to ask for a similar solution with luck in this question: http://stackoverflow.com/q/33112330/5090027 – Grade 'Eh' Bacon Jan 22 '16 at 18:43
  • Hi user1342645. Did you abandon this question? There seems to be a good answer below. I assume you no longer need it for yourself, but at least accept the answer please. To do so, click the tick mark adjacent to the answer, so that it turns green. – halfer Sep 18 '17 at 18:07

1 Answers1

1

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

Gary's Student
  • 95,722
  • 10
  • 59
  • 99