hi,

im sure this question has been asked many times and its a really simple answer, but ive searched and my brain is going to explode in a minute

ive got a large list of Names in colum C of a worksheet called 'Raw Data'.
they are in alphabetical order.

All i want to do is return 1 instance of each name into another list.

i.e

original List:

John smith
John smith
John smith
John smith
John smith
Kenneth Smith
Kenneth Smith
Kenneth Smith
Kenneth Smith
Luke Jones
Luke Jones
Luke Jones
Luke Jones

New List:

John Smith
Kenneth Smith
Luke Jones

any help greatly appreiciated.
jarv.

version: excel 2003.