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. 

​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.      Read More

​