Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Display Evaluate Formula step-by-step on Sheet?

  1. #1
    Join Date
    31st March 2017
    Posts
    28

    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
    VB:
    =INDEX($B$1:$B$6;MATCH(D1;A1:A6;0)) 
    
    
    I want the expected result as shown below
    VB:
    =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 Images Attached Images

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    31st March 2017
    Posts
    28

    Re: Display Evaluate Formula step-by-step on Sheet?

    any? (if possible)

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,214

    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

  4. #4
    Join Date
    31st March 2017
    Posts
    28

    Re: Display Evaluate Formula step-by-step on Sheet?

    Thank you @KjBox

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    10th January 2007
    Location
    Borneo
    Posts
    3,214

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Step Calculation Formula
    By JonesZoid in forum Excel General
    Replies: 7
    Last Post: April 14th, 2007, 21:54
  2. Code runs fine step by step but not when executed
    By Metalastic in forum Excel General
    Replies: 1
    Last Post: April 28th, 2006, 03:43
  3. correlation matrix vba step by step
    By milyenabox in forum Excel General
    Replies: 16
    Last Post: February 4th, 2005, 00:06
  4. how do u install excel? step by step?
    By gora in forum Excel General
    Replies: 1
    Last Post: May 9th, 2003, 10:24
  5. Playing Excel step-by-step as H/W simulator [SOLVED]
    By electron in forum Excel General
    Replies: 4
    Last Post: April 30th, 2003, 00:29

Bookmarks

Posting Permissions

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