Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: How can I compare formulas?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Trussville, AL
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Trussville, AL
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Trussville, AL
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  7. #7
    New Member
    Join Date
    Jan 2011
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How can I compare formulas?

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •