H

I have 2 worksheets of client information that I need to sort by the empl_ID. The Empl_ID is the unique identifier for each client. There are 678 records in one sheet and 789 records in the other sheet

Each sheet may have some identical Empl_ID which is fine. BUT sheet 1 may have Empl_ID which are NOT in sheet 2 and Vice Versa

What I need to do is to have a way merge both sheets into a new worksheet showing only one of each Empl_ID. For instance, if both sheets have an identical Empl_ID, I only want to see it once in the new sheet. Also, anywhere where there is only an Empl_ID in one of the sheets, this Empl_ID will need to be pulled in also. So, from 678 records in sheet 1 and 789 records in sheet 2, we may end up with a NEW WORKSHET containing 900 or so records

I hope this makes sense

Any help will be greatly appreciated

Kind regard

Malcolm Davidson

Copy both sets of ID's to a column in a new worksheet.
Add a header in row 1
select your data and do:
data|filter|advanced filter
copy it to a new location (B1?)
and check unique records only.

Debra Dalgleish has instructions for the advanced filter at:
http://www.contextures.com/xladvfilter01.html#FilterUR

(If there's data associated with each ID, you could use =vlookup()'s to return
as much as you want.)

Malycom wrote:

Hi

I have 2 worksheets of client information that I need to sort by the empl_ID. The Empl_ID is the unique identifier for each client. There are 678 records in one sheet and 789 records in the other sheet.

Each sheet may have some identical Empl_ID which is fine. BUT sheet 1 may have Empl_ID which are NOT in sheet 2 and Vice Versa.

What I need to do is to have a way merge both sheets into a new worksheet showing only one of each Empl_ID. For instance, if both sheets have an identical Empl_ID, I only want to see it once in the new sheet. Also, anywhere where there is only an Empl_ID in one of the sheets, this Empl_ID will need to be pulled in also. So, from 678 records in sheet 1 and 789 records in sheet 2, we may end up with a NEW WORKSHET containing 900 or so records.

I hope this makes sense.

Any help will be greatly appreciated.

Kind regards

Malcolm Davidson

--

Dave Peterson