sort and delete duplicate data

[rohit43]

Hi! All,
I am working on an excel sheet which would have an exclusive id number and then comments/scores against each number. We can sort out the data based on the id number.
Is there any way to sort only the duplicate entries (based on the id number) so that I can delete them all at same time

[nemo74]

a sample sheet would be peachy,

but can't you use the remove duplicates tool?

[IanHyman]

If you look under the Data Tab, you can see a "Remove Duplicates" button. Highlight the the column with the ID numbers, then click expand the selection to encompass all your data, then just check the column you want it to remove.

[rohit43]

Super awesome....thanks IanHyman