Considering that some cells contain repeating values is there a way to get a result of unique occurrences.

For example from following range of cells:
enter image description here

Achieve the following output in target cell "9ll br1 8sd" (similar to what TEXTJOIN returns but avoiding duplicates)

  • Hi Volna, is that something you what to see/accomplish with the filter on?
    – Jacob Jan
    Commented Dec 8, 2020 at 11:04
  • 1
    Hello, @JacobJanTuinstra after some reading it seems like it is, but for now suggestion from Yagisan does the job. But thank you very much for the help :-)
    – volna
    Commented Dec 8, 2020 at 12:15

1 Answer 1


In response to your TEXTJOIN example, you could do this:

  =JOIN(" ",UNIQUE(A3:A8))

The UNIQUE function finds all first unique values.

  • This suggestion solves the problem. Thank you, Yagisan :-)
    – volna
    Commented Dec 8, 2020 at 12:16

Your Answer

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

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