Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |||
master workbook & hyperlinks | Excel Discussion (Misc queries) | |||
How can I create a chart to compare multiple data series? | Charts and Charting in Excel | |||
Compare 2 columns and choose one and enter answer in third column | Excel Worksheet Functions | |||
Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
Create a tabular control | Excel Discussion (Misc queries) |