'How to resolve Excel not removing duplicates?
Probably a dumb question, but I'm having an issue where Microsoft Excel is successfully finding duplicates and SAYING its deleting them in my CSV file, but not actually deleting them or otherwise making any change to the file. I usually have no problem at all, but I suspect the issue may have to do with the unusually large file size I'm working with today.
To walk through my steps for better troubleshooting, I have columns A-AC, I am selecting column E, which is a list of usernames. I go to the top bar, select data > data tools > remove duplicates. There is a popup menu that confirms if I want to select that column, I select "continue with current selection", then select "ok" and "remove duplicates". It says it's removed the duplicates displaying the expected/correct number (see screenshot), but then no changes are made. If I follow the same steps again, I get the exact same results. As an experiment, I tested it in a separate CSV file with only the top 20 rows, and it worked perfectly fine. But with the other file that has 15k rows, it doesn't work. My goal is to remove any rows that contain a duplicate username in column E.
Any idea what's going haywire?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|