Oct 06 2021 12:24 PM
So a little bit of background, I am using the TEXTJOIN and IF statement to pull multiple values from one tab and pull them into one cell on a tab. This works and the values are pulled in the problem is then the output has duplicate values that I want to filter out using the same formula. This is the formula I am using =TEXTJOIN(",",TRUE,IF('SC Data'!B2:$B$3856='Commodity Tracker'!A2,'SC Data'!$D$2:$D$3856,"")) This is the output
2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461,2D-05021461 |
The version of excel I am using does not support UNIQUE function unfortunately. I have seen people using the MATCH function but for some reason I just cant wrap my head around it. Thanks a ton!
Oct 06 2021 12:34 PM
Please check this thread Removing duplicates when using TEXTJOIN - Microsoft Tech Community
Oct 06 2021 12:39 PM
Oct 06 2021 01:27 PM
You may try
with array formula
=TEXTJOIN(", ", 1,
IF( COUNTIF(A2,B2:B28)*
( MATCH(C2:C28,C2:C28,0) = (ROW(C2:C28)-ROW($C$1)) ),
INDEX( C2:C28, ROW(C2:C28)-ROW($C$1) ),
"") )