can somebody tell me if this is possible. I have a spreadsheet with quiet alot of data. how could I search column1 for duplicates without specifying any criteria. in otherwords, I just want to tell excel, go to column1 and find all the duplicate entries. is this possible?