Remove Duplicates

[meggles]

I'm having a problem deleting duplicates from list in excel. I’ve attached a sample. I’ve tried the following:

1- Advanced Filter, Unique Records Only
2- Remove Duplicates function in Excel 07.
3- Pivot Table
4- Colour Conditional Formatting, sorting by colour
5- B2=IF(A2=A3,”Dup”,”Not-Dup”). The entire column returns “Not-Dup”
6- I’ve tried to resolve using the fix shg & teylyn suggested to Hillto in this thread, but am unable to get the ‘Numeric’ Keypad to appear in the ‘Find’ Function. (http://www.excelforum.com/excel-prog...uplicates.html)

Can anyone please let me know if I have the same problem as Hillto had? If not, any idea what the problem is?

thanks in advance!