Combine two spreadsheets

[Clash]

Hi All,

I currently have is two spreadsheets (two different depts.) with, in some cases the same clients on each, each client have a dedicated ID made up of initials, DOB and Postcode (A/B-10/10/72-CV4/4RT).

What I'm trying to do is combine both spreadsheets dataset onto one, based on the ID and all the ones who aren't on both are preferably left off the new spread sheet.

Many thanks

Clash

[rcm]

the best way to get help is to provide a non-sensitive sample of the 2 spreadsheets

one approach would be

1. make a copy of the largest workbook

2. copy the second one into the new workbook (provided they have the same structure)

3. filter the duplicates

[Clash]

Hi rcm

there goes the issue, the two spreadsheets are not the same format and they'd be too difficult to redo as their linked to others.

[Clash]

Hi All,

I Think I've found a way by adding; =IF(COUNTIF(Sheet2!$A:$A,$A2)>=COLUMNS($D2:D2),INDEX(INDEX(Sheet2!$B$2:$B$6,MATCH($A2,Sheet2!$A$2:$A$6,0)):INDEX(Sheet2!$B$2:$B$6,MATCH($A2,Sheet2!$A$2:$A$6,0)+COUNTIF(Sheet2!$A:$A,$A2)-1),COLUMNS($D2:D2)),"")

Thanks for looking though.