Creating a list of text entries without duplicates
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.
Help Article Resources
Check out the Formula Handbook template!