How to Compare formulas???

[arfanvilla]

Is there a formula or VB code that will compare formulas in two different cells and not compare the return value.

For example

A1 contains =SUM(E1:E3) and returns 10
B1 contains =SUM(E1:E3) and returns 20
C1 contains =SUM(F1:F3) and returns 10

D1 will include a formula that will compare the formulas within A1 and B1 and return a TRUE value as the two formulas are identical even though the returned values are different (10 and 20).
D2 will compare the formulas with A1 and C1 and return a FALSE value as the formulas are different even though the returned values are identical.

Hope that is enough explanation and thanks for any solutions or tips.

thanks
Arfan

[MickG]

Hi, This UDF seems to work:-
Right click sheet tab, select, "View Code"
VB Window appears, Click "Insert","Module" on toolbar.
Paste Code in New Window.
Enter Function in sheet as :- oFm(rng1,rng2)
NB:-(rng1/2 = Your cell selection)
Return Value = "True", "False" or Nothing if there is No formula

Please Login or Register  to view this content.

Regards Mick

[arfanvilla]

You my friend are an absolute legend, thank you.

I can now also use this in the conditional formatting.