1

I have a table to combine text with conditions if in column A there is a duplicate number, then in the text in column B combined. The formula that I have made like this:

=IF(COUNTIF($A:$A,A2)>1,TEXTJOIN(",",TRUE,B2:B),"")

But the results do not match, the results I want in column E. enter image description here

Improve this question

1 Answer 1

Reset to default
0
  • paste in a cell on the first row:

=ARRAYFORMULA(IF(IF(LEN(A2:A), IF(((COUNTIF(A2:A, A2)<>
 COUNTIF(INDIRECT("$A$2:A"), A2:A))+(MATCH(A2:A, $A$2:$A, 0)<
 ROW(A2:A)-1))>1, TRUE, ), )=TRUE,
 {""; IF((COUNTIF($A$2:$A, $A$2:$A)>1), B2:B, )&
      IF((COUNTIF($A$2:$A, $A$2:$A)>1), B3:B, )}, ))

Improve this answer
3
  • Does this formula not apply if the duplicate number is more than 2?
    – Lutfi Creativesys
    Feb 20, 2019 at 3:35
  • I guess it does not if there are 2+ consequential duplicates in A column
    – user0
    Feb 20, 2019 at 4:06
  • 1
    Ok thanks for help sir. Problem solved.
    – Lutfi Creativesys
    Feb 20, 2019 at 12:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.