Forum Discussion
palmervilagi
Oct 19, 2022Copper Contributor
urgent help needed
I need help w removing duplicates from a SINGLE COLUMN in excel. https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d this article has a sectio...
dscheikey
Oct 19, 2022Bronze Contributor
What is not working? Can't you find the option in the menu? Is the expected result not coming out? What is the problem?
- palmervilagiOct 19, 2022Copper ContributorI found it but doesn't work to remove duplicates in that one column. says none found
- dscheikeyOct 19, 2022Bronze Contributor
Basically the function "Remove Duplicates" works.
Tested in Excel for the Web.
Are you sure that you have duplicates? Take two cells that you assume are duplicates and compare them with e.g. A1=A2. If the result is TRUE, it is a duplicate.