Deleting Duplicate Rows In Excel

[sheem]

Deleting Duplicate Rows In Excel






It's surprisingly simple. What you do is make a copy of your data that leaves out the duplicate rows.

• Click somewhere in the data area.
• Select Data | Filter | Advanced Filter from the menu.
• Check the Unique records only box.
• Click OK. This hides all the duplicate rows.
• Highlight the slimmed-down data area.
• Copy/Paste the data to a new location.

The copy will omit the hidden rows, so you now have a version of your data with no duplicates.

[Muhammad Khalil]

Re: Deleting Duplicate Rows In Excel

nice Info

[Yaaram]

Re: Deleting Duplicate Rows In Excel

good tip :rose