Combine,match and align 2 excel sheets. [Closed]

Report
Posts
1
Registration date
Thursday May 8, 2014
Status
Member
Last seen
May 8, 2014
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
I want to combine two excel sheets. First excel sheet has patient ID (below 18 years) and their gender, age and race.Second one has patient ID (above and below 18 yrs old) and their lab result. I want to combine and align the Patient ID, age, gender, race and labs to keep only below 18 yrs of age.

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Anvit, Good evening.

Probably you can do this using a VLOOKUP function for a dinamic values or you can use a VBA CODE for a permanent values.

Please, save your files at a free site, www.speedyshare.com, and put a link to download here.

It's easy and possible to help when we can see the layout of your data.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!