Is there a quick way to remove duplicates in a append formula?
When I insert the formula in column E I get duplicates.
=A1 & ", " & B1 & ", " & C1
I would like for column E to show Blue,Red for row 1 and Blue,Red,Green for row 2 thus removing the duplicates
Thanks
When I insert the formula in column E I get duplicates.
=A1 & ", " & B1 & ", " & C1
I would like for column E to show Blue,Red for row 1 and Blue,Red,Green for row 2 thus removing the duplicates
Thanks