Asymmetric data matching

Dear all,

I'm attaching the final sheet for my project

In brief

Similar entries from columns A & B to be matched with the rest of the columns

NOTE : Entries in column A directly correspond with F, G, H and I
Entries in column B directly correspond with C, D and E

This is related to my earlier thread

http://www.excelforum.com/excel-gene...ut-to-4th.html

hi achilles.

Specify your required Output manually .

Punnam

There are some similar entries in A & B

And as mentioned, entries in A directly correspond with F,G,H and I

And B corresponds with C,D,E

So I want all this data extracted into another sheet or same sheet in columns beyond I

hi achilles.a .

Sorry to say your requirement is still not clear .
is this what your are trying to achieve
1) Copy Similar Tissue ID in column A & B to a separate Sheet
2) Then bring the corresponding data like data Column A : F,G,H and I and for Column B : C,D,E
If not clear me
Punnam

My apologies for being unclear

Punnam..you are correct 100%

Finally there will 1 excel sheet with columns from A to H (as A and B will be merged)

Hi,

Please check the updated workbook sheet2 .

Punnam

Here's my take on this - very similar to the previous file I sent to you.

Hope this helps.

Pete

Hello all

My apologies for the confusion

There was some miscommunication between me and the staff

I'm resubmitting the files for analysis for the year 2012..the age and gender I'll add manually later

Once the solution is found, I'll replicate for the later years

Apologies once again

Specular file contains data which is of interest and is a subset of the Surgery 2012 file

I need the common entries combined across both the workbooks

Thank you

See attached file, which explains the steps to take.

Hope this helps.

Pete

Thank you Pete for your reply

For 2013 and 2014 data, I have to follow which steps? The one you mentioned in 2012 sheet or common sheet?

Do both.

To make it even easier for you, I've removed all the data so you can use the attached as a template.

Do what it says in the Data sheet first, then the Common sheet. Use File | Save As to save the file with a different name, so the template remains unchanged.

Hope this helps.

Pete

I've only looked at the 2013 file - you seem to have got the hang of it, although you have copied the formulae in the Common sheet further than you need to (to row 247), so you end up with a few blank rows in the Analysis sheet (do CTRL-End to find the last used cell).

If you are pasting in the Age and Gender, ensure that the rows tie in with those in the Analysis sheet.

Please mark the thread as SOLVED if you think it is.

Pete

Everything seems to be in order now

Thank you Pete for all your help and understanding

This forum rocks