View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Little pete Little pete is offline
external usenet poster
 
Posts: 26
Default 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