Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
how can I set up a master template and have the changes copied to. | Excel Worksheet Functions |