How to find and remove repetitions in columns?

Question

Microsoft

Good afternoon. There are data in several lines in excel'e. It is necessary to find unique numbers, thereby
removing repetitions. For example:
1-ая строка 5555, 5596, 5577, 6698
2-ая строка 5555, 5577, 55223
How to do it? Thanks

Answer 1

If you often work in Excel, I strongly recommend you the PLEX
add-in. A lot of operations are done in a couple of clicks, here's yours .

Answer 2

You can also upload the file to Google Sheets and apply the UNIQUE(array) filtering function to the array which: “Returns unique rows from the original array, skipping duplicates. The order of the strings in the new array corresponds to the order in which they were placed in the original one.

Answer 3

In the same place it is possible to write on VBA, afair.
I remember once writing a support function, though I spat on the BASIC, but still forced out 10 lines.

Answer 4

PLEX and all things, but the most true way is to save it in csv and parse it with awk, well, or python :-)

Answer 5

I treated like this on the camera www.youtube.com/watch?v=76vQUkPAcUw