I have a worksheet where I have the records sorted in a particular order. I am using the remove duplicates function within Excel 2007. I am hoping that it will automatically keep the first record found for each set of dupes. Can anybody confirm if this will be true.