I have a field that is sorted...happens to contain email addresses...and I want to eliminate duplicates. My thought was to create a new column and use =if(e1=e2,"duplicate","unique") and then sort by that column and delete the rows with the word "duplicate" in it. It is not sorting. Is it because of the formula rather than the cell value? I tried formatting the column as text but that didn't seem to help.