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

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, )}, ))

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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