Hi all,
Good day again!
I would like to ask for your expertise on the following:
I am currently working on an excel sheet where it contains 1000+ data, the problem is, the data contains A LOT of duplicates. Now, I tried removing the duplicates, it removed the duplicates as expected, however, the lines have been adjusted -- which I do not want to happen (lines being moved). I just want to remove the duplicate without affecting the lines.
Here's an example of the list (changed the name for privacy reasons):
There are over 15 columns per line, and there are over 1000+ lines. I tried the conditional formatting where it would highlight the duplicate values, but removing them manually would take me weeks or possibly months. Would there be a better way to sort this?
I really hope you can provide me your guidance on this.
Best,
Priv
P.S - Edit, I've tried searching for other posts and even through Google, but none of the answers seem to work for me. (Or I might just be doing it wrong [for the CountIf function which I saw as an answer])
Good day again!
I would like to ask for your expertise on the following:
I am currently working on an excel sheet where it contains 1000+ data, the problem is, the data contains A LOT of duplicates. Now, I tried removing the duplicates, it removed the duplicates as expected, however, the lines have been adjusted -- which I do not want to happen (lines being moved). I just want to remove the duplicate without affecting the lines.
Here's an example of the list (changed the name for privacy reasons):
There are over 15 columns per line, and there are over 1000+ lines. I tried the conditional formatting where it would highlight the duplicate values, but removing them manually would take me weeks or possibly months. Would there be a better way to sort this?
I really hope you can provide me your guidance on this.
Best,
Priv
P.S - Edit, I've tried searching for other posts and even through Google, but none of the answers seem to work for me. (Or I might just be doing it wrong [for the CountIf function which I saw as an answer])
Last edited: