Removing duplicate rows

[nclacs99]

Hi all, I have a worksheet that contains many "duplicate" rows. I need to remove all the duplicate rows. Is there a quick way to do this? Thanks!

 

[Momentman]

Do you want to remove the other instances of the value that is duplicated i.e leaving only one instance or do you want to remove all the entries that occur more than once

Have you tried the "Remove Duplicates" feature under the data tab

 

[nclacs99]

I would like to remove the other instances of the value. Thanks for the tip Momentman. I was not aware of the "Remove Duplicates" feature. It worked perfectly! (I knew there had to be an easy way to do it)

 

[Momentman]

We all learn everyday. You are welcome