Previous Topic Next Topic

Combine,match and align 2 excel sheets.

Closed
Anvit Posts 1 Registration date Thursday May 8, 2014 Status Member Last seen May 8, 2014 - May 8, 2014 at 01:30 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 8, 2014 at 07:47 PM
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.
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 8, 2014 at 07:47 PM
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