Looking for a way to return unique text values from another sheet.
I have a sheet that includes a long list of parts and materials, across multiple products, so there are a lot of duplicates. I need to create a list of each individual part, one instance per part, regardless of how many there are on the source list. In Excel I would use this formula - "=SORT(UNIQUE(ALL_PRODUCT_BOM_TABLE[PART NUMBER]))", where "ALL_PRODUCT_BOM_TABLE" is the table I'm pulling from, and "[PART NUMBER]" is the column containing all of the part numbers that I need to sort.
I've seen the Distinct command, but I cannot get that to work, I suspect it is because that needs to be nested in another formula. I also see some people referencing an Index method, but I can't get my head around how that works yet...
Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!