I have a list of 665 elements and I need to make a list with only unique elements.I have tried 'Advance Filtering-Unique values only' function, but somehow the resulting list still contain duplicate elements. Attached is the list. Column 1 is raw list and column 2 is the list obtained by using the function. I have tried doing it in Excel2003 and Excel2007 but its still not working. Any help is greatly appreciated.
Bookmarks