I've seen macros and UDFs that I think can do this, but I'm looking for a standard formula if possible.
Given:
- Cells containing single or multiple values separated by a comma.
- A cell can contain any number of duplicates of any value.
- Length of values varies (single characters used in example below to simplify).
Desired result:
- Delete the duplicate values within cells, leaving one unique value from among the duplicates.
- Values in the resultant cell can be in any sequence, if that simplifies anything.
Example:
- Cell contains: [A, B, C, C, F, C, E, F, A, C]
- Desired result: [A, B, C, F, E] or [C, A, E, B, F] etc.
TIA for any help!
Bookmarks