How to find and remove repetitions in columns?

O

Oleg2012-07-09 07:33:15

Microsoft

Oleg, 2012-07-09 07:33:15

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

Reply

Answer the question

In order to leave comments, you need to log in

5 answer(s)

B

BiBo, 2012-07-09
@BiBo

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 .

B

BiBo, 2012-07-09
@BiBo

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.

M

mark_ablov, 2012-07-09
@mark_ablov

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.

A

Alukardd, 2012-07-09
@Alukardd

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

F

fenst, 2012-07-09
@fenst

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