Feedback by UserVoice

Craig Hatmaker

My feedback

  1. 1,567 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Craig Hatmaker supported this idea  · 
  2. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
  3. 48 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker shared this idea  · 
  4. 43 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
    An error occurred while saving the comment
    Craig Hatmaker commented  · 

    Structured references make formulas self documenting. Please extend the self documenting concept to data validation list sources by accepting structured references there as well.

  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
  6. 21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Craig Hatmaker commented  · 

    Sorry - I focused too much on the solution and not enough on problem. The problem is dynamic arrays currently cannot distinguish when an element in an array is not dependent on values in the same column that reference it. In this case, the opening balance is pulling a value from the prior closing balance column and not the current closing balance column. So when a closing balance cell adds the opening balance from the same column, it is NOT a circular reference.

    An error occurred while saving the comment
    Craig Hatmaker commented  · 

    Hi Kenneth Barber,

    Thank you for your comments.

    Your assumptions hold true for traditional Financial Modelers who structure models in chronological order (horizontally) with no duplicates. Dynamic Arrays hold great promise for Financial Modelers by making models:

    1) Dynamic - by automatically accommodating any number of periods with no formula changes
    2) Robust - by dramatically reducing formula cell count (failure points).
    3) Efficient - by dramatically reducing distinct formula count.

    Spilled arrays cannot be placed in tables making tables and dynamic arrays two totally different paths for modelers. Personally, I prefer tables because Structured References make formulas self documenting and more transparent (see https://arxiv.org/ftp/arxiv/papers/1802/1802.01628.pdf). For those wanting to learn about table based modeling see my site: https://sites.google.com/site/beyondexcel/project-updates/advancedexcelmodeling-introduction

    Dynamic arrays could work for Financial Modelers if they had a "corkscrew" function that was simple. I believe this suggestion is the only path to adoption by traditional Financial Modelers. Please vote for it.

    Craig Hatmaker shared this idea  · 
  7. 30 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
  8. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
  9. 84 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 
  10. 393 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    An error occurred while saving the comment
    Craig Hatmaker commented  · 

    MLookup( GetFromThisRange, [WhereThisRangeMatches, ThisCriteria]...)

    Where what is in brackets [ ] can be repeated just like SUMIFS.
    Return an array if multiple values match criteria.
    And please let it be Structured Reference friendly

    Craig Hatmaker supported this idea  · 
  11. 15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Craig Hatmaker supported this idea  · 

Feedback and Knowledge Base