I have the following in a field:Value 1, Value 2, Value 3, Value 4, Value 5, Value 1, Value 2I need a formula to show me the repeated values:Value 1, Value 2Alternatively, I have another field with the unique values of: Value 1, Value 2, Value 3, Val...
I am hoping there is a formula to achieve this... but not sure. I want to automatically generate the formatting that is in the "IDEAL" field on the right, that way this does not have to be done manually.Any help/thoughts would be appreciated!
