Oct 19 2022 10:12 AM
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-66a552...
this article has a section on remove duplicate values but it won't work
Oct 19 2022 10:26 AM
What is not working? Can't you find the option in the menu? Is the expected result not coming out? What is the problem?
Oct 19 2022 10:55 AM
Oct 19 2022 11:32 AM
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.