Distinct Formula

Nichole

Hello!!

Thank you in advance for any assistance you can provide me.

I have 2 columns (Assignee, Total Tickets) - Assignee is comprised of a list of names (most are formatted as email but a few are stated names). I need to create a formula that will provide me a listing of unique names (thus removing the duplicates). For Total Tickets, I am sure that is a second formula that I will tackle to provide the corresponding number of tickets assigned to them.

I have been trying to use Distinct in the formula but I keep getting UNPARSEABLE or a count of 1 instead of names -- I am unsure of where I am going wrong.

This is what I have tried ---

=IF(COUNTIF(Assignee$1:Assignee@row,=[Assignee]@row)1, 1, 0

Thank you,

Nichole

MCorbin

Try this:

=JOIN(DISTINCT(COLLECT(Assignee1:Assignee7, Assignee1:Assignee7, <>"")), ", ")

Nichole

Hello,

Thank you for the assistance. I no longer receive an error message or a 1, but the duplicates are still showing. Any suggestions to get them removed?