Duplicate rows, or almost duplicate

Rickalty

New Member
Joined
Sep 16, 2002
Messages
3
Hi everyone.

I have to merge two identically laid out Excel spreadsheets, of 11 columns. One is about 4000 rows, the other about 7000. My problem is this - some of the rows exist in both spreadsheets, and I want to delete all the duplicate rows. First, how do I do this?

Second, some of the rows 'are' duplicates, but aren't actually identical. Let me expand on that...

The first column contains ships names, the other columns contain data about them.

There might, for example, be a row where the ship name is "Seariver Baytown", and also a row containing the same information, but with the name as "Sea River Baytown". Also, there may be the same data in two rows, but one person entered the data using decimal places for the numerical values, the other rounded to a whole number. How can I 'fuzzily' compare the rows to get an option to manually confirm whether two rows are - or aren't - the same cargo?

Thanks for any ideas,

Richard
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,477
Members
414,070
Latest member
DuncanLucas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top