ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   comparing 3 s/s to make up a master (https://www.excelbanter.com/excel-worksheet-functions/127219-comparing-3-s-s-make-up-master.html)

Little pete

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