HELLP PLEASE HELP

ilyas star · 04/14/21

I have issues to getting the unique names?

Bassam Khalil · 04/14/21

Hope you are fine, please clear if you want to collect all unique names in one cell. if so then please use the following formula.

=JOIN(DISTINCT(Categories:Categories), " - ")

the following screenshot shows the result

ilyas star · 04/14/21

Exctly what i want

But please the refreance is another sheet

aslo i want the data one by one not one cell thanks

ilyas star · 04/14/21

i mean collect all unique names in cell one by one

ilyas star · 04/14/21

I hope get any replay !

Answers