How do I concatenate multiple rows if they are the same / if they equal true?

Hi Andrew,

I'm puzzled by the tokens labeled "Image 4102" and "image 4757" in your formula. The tokens indicate that this is a cell reference, using column and row header labels, but the first two tokes use the column and row index values. Since the preference choice for this applies globally within the document, I'm wondering how this mismatch occurred.

This should do what you have described:

The formula shown below the table is entered in C2, and filled down the rest of the column.

Regards,

Barry

CONCATENATE would have worked I think. It looks like you were concatenating a wrong cell. Also, your IF formula did not have the third parameter that said what to do if the result was false.

While it was not a problem, you were also mixing CONCATENATE and the & operator (which does the same job) where you could/should have used one or the other. =CONCATENATE(C1, ", ", B2) is the same as =C1&", "&B2

Hi Andrew,

"Evidently, using concatenate for this wasn't going to provide the results I needed."

As Badunit has already noted, CONCATENATE would have produced the same results as &, the concatenation operator. My primary reasons for preferring the operator here are its simpler syntax and shorter formulas.

Regards,

Barry

Thanks for the green checkmark! Always appreciated.

@ **: Thanks for the explanation on cell reference labelling in the newer versions of Numbers. I think I'd find this counter-productive when trouble-shooting a formula—especially if the behaviour is the same with a cell containing an 80 character string, rather than a four digit number!

B.

"cell reference labelling in the newer versions of Numbers. I think I'd find this counter-productive when trouble-shooting a formula—especially if the behaviour is the same with a cell containing an 80 character string, rather than a four digit number!'

Hi Barry,

I wasn't sure about that token either. I couldn't reproduce it in Numbers 5.3, even with 'Use header names as labels' checked in Numbers Preferences... until I added a Header Column containing the image numbers, like this:

So the reference is to the column labeled 'Image' and the row labeled '4757'. The '4757' is from the value in the Header Column for that row, not from the value in the cell itself. That is consistent with Numbers for iOS. I find those labels sometimes can be useful in constructing formulas, much like named ranges in Excel. In Numbers for Mac one can always turn off 'Use header names as labels'. That can reduce confusion when posting here.

SG

My mistake, I was looking at Barry's table not the one in the original post. The original has "Image" in column G which is too far right to be a header column. So SGIII's answer is the only one that seems possible (so far anyway).

Ha. Still wrong. It was column H. Jeez.

To explain the cell references, the table has two header columns (A & B), one of which is the column labeled "Image" that has the numbers in it. So a reference to a cell in that column gets the name "Image" followed by the number in the cell.