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:


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

  • paste in a cell on the first row:

 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? Feb 20 '19 at 3:35
  • I guess it does not if there are 2+ consequential duplicates in A column
    – user0
    Feb 20 '19 at 4:06
  • 1
    Ok thanks for help sir. Problem solved. Feb 20 '19 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.