Announcement

Collapse
No announcement yet.

Display Evaluate Formula step-by-step on Sheet?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Display Evaluate Formula step-by-step on Sheet?

    I believe that you are familiar with the "Evaluate Formula" that shows formula step-by-step calculation.
    Is there an option (some free Add-in for Excel or VBA code) that will separate all calculation steps of a formula into a new Sheet.
    Have any of the members of the forum URL link or advice or perhaps VBA code?

    Example formula
    Code:
    =INDEX($B$1:$B$6;MATCH(D1;A1:A6;0))
    I want the expected result as shown below
    Code:
    =INDEX($B$1:$B$6;MATCH(D1;A1:A6;0))
    =INDEX($B$1:$B$6;MATCH(7;A1:A6;0))
    =INDEX($B$1:$B$6;3)
    300
    Please see attached image
    Attached Files

  • #2
    Re: Display Evaluate Formula step-by-step on Sheet?

    any? (if possible)

    Comment


    • #3
      Re: Display Evaluate Formula step-by-step on Sheet?

      I am fairly certain what you want is not possible.
      We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

      Comment


      • #4
        Re: Display Evaluate Formula step-by-step on Sheet?

        Thank you @KjBox

        Comment


        • #5
          Re: Display Evaluate Formula step-by-step on Sheet?

          You're welcome.
          We now have a reputation system in place. It can be found on the 'Star' icon on the bottom left hand side of the post

          Comment

          Working...
          X