If you just have the one column and would like the duplicates removing, you could use the advanced filter.
Make sure you have a column heading, select the cells you want to be filtered, click on Auto-Filter and check the Copy to another location and Unique Records Only boxes, click on a location where you want to the new list to be placed and click OK. HTH.
This message was edited by Mudface on 2002-03-14 12:01