Filtering out repeated numbers

P

PaD

I currently work with large lists of part number, sometimes within these
list there are repeated part numbers that I do not require in the list,
so rather than sort the list into partnumber order and then scroll
through and delete all but one of the repeated part numbers (which when
you have lists of up to 3000 different parts can take up a serious
ammount of time) I was wondering if it were possible to filter the list
down to just one of each Part no.

i.e changing the list on the left to the list on the right as simply
as possible!

1...............................................1
1...............................................2
1...............................................3
2...............................................4
2
3
4
4
4

Any help would be greatfully appreciated,

PaD
 
A

Alan

Go Data > Advanced Filter and highlight your list, select Unique Records
Only, select Copy To Another Location and enter a cell reference in an empty
column >
OK
You now have your list with all the duplicates removed,
 
Top