F Frank Kabel Mar 16, 2004 #2 Hi have a look at http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows