I have a list of entries in columns H
, I
, J
. The column K
is a helper column which concatenates the three. This is done to check the number of repeats within the range (Column L
).
Now that I got the number of repeats, I entered formula in the column M
:
=IF(COUNTIF(L3,">0"),K3,"")
And I got the following picture of unique values from column L
:
I would like the next column (N
) to enlist all the unique combinations of these values, but without blank cells between them.
Is it possible to do with a WS formula?