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
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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.
0