Is there a way to keep only the longest values of a unique sequence? For example, if we have the following list:
Test
Test123
Test12345
Test67
Test689
Example
We would want to be left with only Test12345, Test689, and Example. The other ones which are substrings would be filtered out.
With a large dataset, is there an automated way to check if it is a substring against all other values in the column to decide if it should be kept or removed? I have been leaning towards using formulas, filters, and fuzzy match, but haven't figured out exactly how to do what I want.
Thanks!