Duplicates

jgneely72151

I have a student sheet that I am copying over for the next semester. I copied only the data but didn't want the comments, attachments, filters, links, etc. However, there are duplicate names on sheet and I want to know if there is an easy way to find those rows and delete them. Any advice is greatly appreciated.

David Tutwiler

The easiest way I can think to do it would be to sort by the name. This should sort all of the names together and allow you to delete the duplicates. If you need the sort to go back to the previous version, I would add an Order column and numbers your entries 1-n and when you're done, resort by the Order column to get your sort back.

bcwilson.ca

I have this formula in a column that looks for duplicate invoice numbers in a sheet

=IF([Invoice #]@row = "", 0, IF(COUNTIF([Invoice #]:[Invoice #], [Invoice #]@row) > 1, 1))

It might help..

In mine it simply counts the occurrences of the Invoice number in the Invoice number column and causes a red flag if the invoice shows up more then once

The red flag show up by putting this formula in a Flag Column

You could also put a conditional format on the row if the value is greater then one

David Tutwiler

The easiest way I can think to do it would be to sort by the name. This should sort all of the names together and allow you to delete the duplicates. If you need the sort to go back to the previous version, I would add an Order column and numbers your entries 1-n and when you're done, resort by the Order column to get your sort back.

bcwilson.ca

I have this formula in a column that looks for duplicate invoice numbers in a sheet

=IF([Invoice #]@row = "", 0, IF(COUNTIF([Invoice #]:[Invoice #], [Invoice #]@row) > 1, 1))

It might help..

In mine it simply counts the occurrences of the Invoice number in the Invoice number column and causes a red flag if the invoice shows up more then once

The red flag show up by putting this formula in a Flag Column

You could also put a conditional format on the row if the value is greater then one

jgneely72151

Thanks David! That is what I had been doing but was hoping something was similar to how I delete dupes in Excel. I think I may export and import again as that is a little time consuming because the list is huge. I do appreciate your fast reply. Have an awesome day!

jgneely72151

@bcwilson.ca Never thought about using a formula. Thanks that's pretty slick and may using it for another project sheet. Have an awesome day as well!

jgneely72151