MERGING COLUMNS WITH DUPLICATE INFO.

[PatrickL]

I really need help.

I have two worksheets with data in columns A-G. Column B has content like
"HDMU4524565". This is in column B of both worksheets. There are multiple
duplicates in Column B on both worksheets. I need to combine the two
worksheets keyed on column B and have no duplicates.

I also need to pull the data in the other columns over that corespond with
the entries in column B.

Example:

Column A Column B Column C Column D Column E Column F
Column G
Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
YES

My boss is on me to do this report more efficiently.

Any help is appreciated.

 

[Duke Carey]

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.

 

[PatrickL]

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?