Forum Discussion
Unique, Filter, Spill, Multiple Unique Identifiers
Hello All - I am running into an issue where I have 200 #'s that I am required to filter by their unique Names. Each of those names come with unique identifiers that are categorized into 4 categories of which category 1 has 5 values, category 2 has 10 values, 3 has 20, and so on. I have been able to figure out a formula, that combines Unique(Filter(Identifier2,Sheet2!NameColumn=Sheet1!Name)*(Sheet2!Identifier1=Sheet1!Identifier1). This formula is to identify unique identifier 2.
Issue being, when I get multiple unique values, I have to go in and manually alter to the next identifier, with some being upwards of 30. Is there another way to this process? Example pasted below.
- Your example, is that the expected outcome? Please post both a sample of the source data along with the expected outcome.
- Thanks, test excel workbook has been attached. There is dummy data on the left hand side with the formula on the right hand side under the header test. Hope this helps.
