Distinct Formula
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
Answers
-
Try this:
=JOIN(DISTINCT(COLLECT(Assignee1:Assignee7, Assignee1:Assignee7, <>"")), ", ")
-
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?
Help Article Resources
Categories
Check out the Formula Handbook template!