Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

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

          Trending

          Collapse

          There are no results that meet this criteria.

          Working...
          X