Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 1 of 1

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

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

    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


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