urgent help needed

Copper Contributor

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

3 Replies

@palmervilagi 

What is not working? Can't you find the option in the menu? Is the expected result not coming out? What is the problem?

I found it but doesn't work to remove duplicates in that one column. says none found

@palmervilagi 

Basically the function "Remove Duplicates" works.

Tested in Excel for the Web.

 

dscheikey_0-1666204041875.png

 

dscheikey_2-1666204128037.png

 

dscheikey_3-1666204159452.png

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.