STEP 1: Select data in Excel sheet and Select 'Remove Duplicates' option from Data Tools section in Data Tab.
STEP 2: Duplicate rows will be removed and following will be the results.
Sunday, April 24, 2011
Removing duplicate rows
Excel provides a very simple tool to remove duplicate rows from a large set of data. Here how it goes:
STEP 1: Select data in Excel sheet and Select 'Remove Duplicates' option from Data Tools section in Data Tab.
STEP 2: Duplicate rows will be removed and following will be the results.
STEP 1: Select data in Excel sheet and Select 'Remove Duplicates' option from Data Tools section in Data Tab.
STEP 2: Duplicate rows will be removed and following will be the results.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment