Editing a Column of Numbers to remove duplicates

  • Thread starter Thread starter S.T.
  • Start date Start date
S

S.T.

I have a list of numbers, eported from another program to
Excel, of which the same number appears two or three or
more times in the same column (this is normal for the
program I exported from) what I want to do is delete the
duplicates so that each number appears only once in the
column.

At the moment I am sorting the column and manually
deleting all the ones I don't want, very time consuming.
 
Try using advanced filter. You can do this via

On the Data menu, point to Filter, and then click Advanced
Filter.

Select the Unique records only option to remove duplicated.

To filter the list by copying rows to another area of the
worksheet, click Copy to another location, click in the
Copy to box, and then click the upper-left corner of the
paste area.

This should eliminate all duplicates, and also preserve
the order of the original list (i.e. no sorting).

Good luck.
 
Back
Top