![]() |
comparing 3 s/s to make up a master
Hi,
I have recieved 2 s/s both of which have been worked on at the same time, changes have not been tracked and there is no consensus which is the master. I have the original s/s to compare too but want to incorporate the most recent changes from each to come up with the Master s/s. All three s/s have the same column and row headings i.e structured the same. I therefore want to identify the questionable data ie the ?? in the below table so this can be reviewed individually. Can anybody help me to write the below IF Statements, my 3 s/s are ORG, MC and BB. The final column represents master spread sheet should answer. Org=MC Org=BB MC=BB MC Org‰*MC Org‰*BB MC=BB MC Org=MC Org‰*BB MC‰*BB BB Org‰*MC Org=BB MC‰*BB MC Org‰*MC Org‰*BB MC‰*BB ?? Thanks for the help Pete |
All times are GMT +1. The time now is 12:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com