how to find duplicates in excel for mac 2008

For example, if your data has seven columns, drag a selection region thats one row high and seven columns wide.

Save 90 Local Sports Things to Do Business Travel Politics Opinions Homes Subscribe Archives Nation Jobs More Cars Video Apartments Shopping Classifieds Insider azcentral tickets Lottery Obituaries E-Newspaper Investigations Comics Buy Photos Apps Giving Back New Home Central Monsoons Business Directory Member Guide Traffic Moonlighting Advertise with Us USA TODAY NETWORK Public Notices Subscribe Home Local Sports Things to Do Nation Now Business Travel Explore Politics Opinion Investigations Marketplace Insider Advertise with Us Obituaries Archives Weather Subscribe How to Subset Data in Excel How to Consolidate Duplicates in Excel How to Merge Excel Spreadsheets to Find Duplicates by Darrin Koltow Related Articles How to Subset Data in Excel How to Consolidate Duplicates in Excel How to Make Excel Data Horizontal How to Make Dates Show Up on the Horizontal Axis in a Chart in Excel How to Eliminate Double Entries in Excel How to Match Data in Excel Spreadsheets Share on Facebook Imagine having two identical computers with identical data on your desk.

The computer you choose not to use is a waste of your companys time, space and money.

Both commands seek identical table rows, and delete all but one of them.

Using Remove Duplicates is best when your only goal is to remove identical data.

Advanced Filter enables deletions of identical data while simultaneously hiding data that doesnt match your search criteria.

Remove Duplicates Step 1 Open a workbook with two worksheets youd like to merge.

For example, if one worksheets headings are Name, Address, Email, the second worksheet should also have these headings.

Step 2 Select all data in the first worksheet, and then press Ctrl-C to copy it to the clipboard.

Press Ctrl-N to create a new workbook, and then press Ctrl-V to paste the first worksheets data.

Return to the first workbook, and then click the second worksheets tab.

Copy its data to the clipboard, and then paste this data directly below the first worksheets data.

Step 3 Select all data in the new workbook, and then click the Data tabs Remove Duplicates command, located in the Data Tools command group.

Click the Select All button to indicate you want to search for rows that are completely identical across all columns.

Excel displays a message indicating how many unique rows remain.

Press Ctrl-S, and then use the Save As dialog boxs controls to save the merged data.

Advanced Filter Step 1 Open a workbook with two worksheets youd like to merge and remove duplicate rows from, and then select the first worksheets data.

Copy the data to the clipboard, and then paste it into a new workbook.

Copy the second worksheets data, and then paste it directly below the first worksheets data in the new workbook.

Step 2 Select all data in the new workbook, and then click the Data tabs Advanced command, located in the Sort and Filter command group.

Click the Action headings Copy to another location option, and then check the Unique Records Only check box.

Leave the Criteria control empty to process all rows in the worksheet.

Step 3 Click the grid-shaped range selector button in the Copy To heading, and then click a cell in a new worksheet.

Drag a selection region that spans a single row and has the same number of columns as your worksheet data.

How To Find Duplicates In Excel For Mac 2008