Compare formula
I have a spreadsheets with 3 worksheets
Sheet 1 holds all the data, calculations etc etc and is 1000 rows x 30 columns
Sheet2 is a library which picks up calc1 from sheet1 - colG (1000 rows x 2
columns)
Sheet3 is the same library which picks up calc2 from sheet1 - ColH (100 rows
x 2 columns)
I need to check that the formula on sheet2, column B link to colG in in
sheet1 & on sheet2,ColB link to colH
The results may sometimes be the same so I cannot simply compare the answers
Ideally I want =if(formula!sheet2!B2 = formual!sheet3!b2,"ERROR")
Any ideas?
|