Problem: Used textjoin to create tables based on an identifier. Textjoin has now created multiple stings of numbers (i.e. "7, 26" and "7, 37") and I can not figure out which function or combination of functions to use retain only the first unique instance of a number.
I have tried the following formula: =TEXTJOIN(", ",TRUE,IF(I2:I22<>"",IF(MATCH(I2:I22,I2:I22,0)=(ROW(I2:I22)-ROW(I1)),I2:I22,""),""))
However, this returns "7, 26, 7, 37, 7" When I only want "7, 26, 37"
I have tried the following formula: =TEXTJOIN(", ",TRUE,IF(I2:I22<>"",IF(MATCH(I2:I22,I2:I22,0)=(ROW(I2:I22)-ROW(I1)),I2:I22,""),""))
However, this returns "7, 26, 7, 37, 7" When I only want "7, 26, 37"