Hello All. This is my first post. I use Excel 2007. I have a sheet where I must delete all duplicate values. I know there is a button that will delete duplicates and leave the original values. Is there a way to not only delete the duplicate values but also the original values that were duplicated in the first place? All help will be greatly appreciated. Thanks...Steve