Aug 29 2018 02:23 PM
I am hoping someone can help me.
I have a column of text numbers, some of which are duplicates. I need to have the duplicate numbers only show up once in a different column (like removing duplicates) - all without using a pivot table.
My list/table is below... can anyone help?
01-6512-0-5210-5060-2200-622-0000 |
01-6512-0-5210-5060-2200-622-0000 |
01-6512-0-5210-5060-2200-622-0000 |
01-6512-0-5210-5060-2200-622-0000 |
01-6512-0-5210-5060-2200-622-0000 |
01-6512-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0631 |
01-6500-0-5210-5060-2200-622-0631 |
01-6500-0-5210-5060-2200-622-0631 |
01-6500-0-5210-5060-2200-622-0631 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-622-0000 |
01-6500-0-5210-5060-2200-597-0000 |
------- |
Aug 29 2018 09:07 PM
Hi Kathleen,
There is an easy way to do this by using the Advanced Filter in Excel.
And this is explained in this video.
I hope this helps you
Haytham
Aug 30 2018 01:47 PM
Aug 30 2018 01:55 PM