Creating a list of text entries without duplicates

Hello!

We have a large "master tracker" sheet where we house all the information about each of our units, one piece of which is a "neighborhood" designation, which basically tells us where on each of our properties the unit is located. Typically, there are somewhere between 6 and 20 units in each neighborhood, and every property has 3-4 neighborhoods. I'm trying to create a reference list of each of these neighborhood names, ideally in a format that doesn't require manual entry of newly added neighborhoods when more are added to our master tracking sheet, but I'm not sure how to pull that information into a list without duplicates, i.e. I want the list to include only one entry for each name.

Thanks!

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Emma Picardi

I hope you're well and safe!

Have you explored using a Report?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Emma Picardi

Hey Andrée, unfortunately a report doesn't do the job since it still pulls in ALL the entries in the sheet rather than a single instance of each neighborhood name. This is the report that I put together a while ago that sort of does the job as long as you keep all the groups collapsed, but ideally we'd like to have a sheet with the individual neighborhood names each in their own row.

Screen Shot 2022-07-27 at 12.40.42 PM.png

Paul Newcome

In the second sheet you would use something along these lines:

=INDEX(DISTINCT({Source Sheet Neighborhood Column}), 1)

The above would pull the first unique entry. Changing that to a 2 will pull the second, so on and so forth.

You can wrap it in an IFERROR to output a blank and prefill enough rows in the second sheet to cover as many as you think you would need.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.