I was using TEXTJOIN(", ",TRUE,IF(A2=Data!E:E,Data!H:H,"")) but this formula provides all the values even if it repeats. I'm looking to remove the duplicate values and only display the unique values.
Basically I have specific items(text) associated with 1 of 70 numbers in a row. Each item should only be associated with 1 of those numbers, but I want to find the anomaly's that have more than 1 number per item. Then I want to display the numbers that each item is associated with.
I'm trying to do a comparitive analysis to see what is the correct number to be using. If there is a simpler way as well let me know. Like in a pivot table that just show items that have multiple numbers and exclude the ones that don't.
Basically I have specific items(text) associated with 1 of 70 numbers in a row. Each item should only be associated with 1 of those numbers, but I want to find the anomaly's that have more than 1 number per item. Then I want to display the numbers that each item is associated with.
I'm trying to do a comparitive analysis to see what is the correct number to be using. If there is a simpler way as well let me know. Like in a pivot table that just show items that have multiple numbers and exclude the ones that don't.