How can I compare formulas?

PDuPre'

Board Regular
Joined
Apr 23, 2002
Messages
134
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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.
 
Upvote 0
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
 
Upvote 0
See the Edit | Go To... Special "Row Differences" and/or "Column Differences" option.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top