79769486

Date: 2025-09-19 12:18:10
Score: 1
Natty:
Report link

I found a newer simpler version:

=IFERROR(TEXTJOIN(", ",TRUE,UNIQUE(B1:K1,TRUE,FALSE)),"")

And also one that works if the cells you want to combine are already lists:

=IFERROR(TEXTJOIN(", ", TRUE, UNIQUE(TEXTSPLIT(TEXTJOIN(", ",TRUE,B1:K1),", "),TRUE,FALSE)),"")
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Jennifer Boshuizen