How can I compare formulas?

[PDuPre']

I have a column of formulas that someone made changes too. Some were good, but others were wrong. I pasted the original column next to the first and now I'd like to compare the two columns of formulas to know which ones I should look at. How can I do this? Seems like all the formulas look at the values in the field and not the formulas.

Thanks,

Phil

[IML]

You could use find and replace (ie find = and replace with abcxyz). You could then use formula such as =Exact() to compare the strings. When finished, find abcxyz and replace with =.

If you don't want to use formulas to compare the formulas, a simple Control Tilde ~ should do it for you.

[PDuPre']

Thanks.

I definately want to use a formula. Way too many. Knew there had to something quick, just couldn't think of it.

Thanks for the quick response.

Philip

[Mark W.]

See the Edit | Go To... Special "Row Differences" and/or "Column Differences" option.

[IML]

Just thought I'd bounce this up again because it is very cool, and I never knew it existed. Nice one!

On 2002-05-07 11:55, Mark W. wrote:
See the Edit | Go To... Special "Row Differences" and/or "Column Differences" option.

[PDuPre']

Very nice solution! Thank-you!
Never knew it existed either.

[sramya]

Guys...
i need help....

I have formulas in one column, say Column C

Row 1 = "=sum(A1:B1)
Row 2 = "=sum(A2:B2)
Row 3 = "=sum(A3:B3")

Now as you see that formula is same and just row precedents are changing.. is there any way to find that two formulas defers only in their row precedents and return true for that i.e. it is same formula.
But as soon as formulas changes like this

Row4 = "=sum(G1:G2)" then it returns false;

i.e.
if first formula is "=sum(A1:B1) and second formula is "=sum(G2:2)" then it should tell that formula is same