I have already blown away the original sheet that had the duplications. I suspect that somewhere I have screwed up and had mixed data types. In order to provide you a spreadsheet to enable us to see where the problem had occurred, I would have to duplicate the spreadsheet and the error(s) within. Having had excel remove duplicates and having eliminated 5 of the columns from the scope of my effort I can not accurately replicate the original sheet and the data within.