MERGING COLUMNS WITH DUPLICATE INFO.
 

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.

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" wrote:

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.

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?


"Duke Carey" wrote:

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" wrote:

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.