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

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.