I want to be able to identify if there's duplicate values within a cell and then delete both.
For example, I have A, B , A, B , C and i want my results to be C. I was thinking I could you a filter tool or formula tool.
How does something like this look?
Have updated my flow @fitch1892:
Hey @fitch1892,
Heres is one way to do this:
Any questions or issues please ask HTH!Ira
Sorry If I wasnt clear, this is my first question and was not aware I couldn't edit itafter I post it. This is the data format I have and I what I want it to look like.
Column 1 | Column 2
X | A,B,A,B,C
T | A,B,A,B
Results to be....
X | C
T |
Heres my updated work
Both worked, thank you! @IraWatt@DateNath
