Function to find duplicate values, then delete

[Guest]

Hi,

I have about 2000 data on Excel file and many have duplicate values
(numberic) in the cell on Column A.
Is there a function that will look for duplicate and delete (or highlight)
all, but one of the duplicate value.

For example:
row 50-59 on column A has a value of 50006420, I like the macro to delete
row 51-59.
Thanks for any help.

 

[Pete]

If the data is sorted, then in B2 you can enter this formula:

=IF(A2 = A1, "duplicate","unique")

and copy down to the bottom of your range of A values. Then you can use
autofilter on column B to select "duplicate". Highlight all the visible
rows and Edit | Delete Row. Then select All in the filter drop-down.

However, the same thing can be achieved by Advanced Filter - highlight
the data in column A (works better with a header), then Data | Filter |
Advanced Filter. Your range is already defined, tick Unique Records
only and decide if you want to filter in place or move the unique
records to another location (specify where). Then click OK and the
job's done.

Hope this helps.

Pete