Feedback by UserVoice

Jeff Robson

My feedback

  1. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jeff Robson commented  · 

    While it's possible to simulate corkscrew functionality using Dynamic Array functions ( https://accessanalytic.com.au/corkscrew-calculations-using-dynamic-array-functions/ ), I agree that this is a pretty ugly and unnecessarily complex solution so would rather support your idea (or the ACCUMULATE function Peter mentioned below) and have these built into Excel.

    There needs to be a simple solution to this problem and it is currently a significant omission that prevents dynamic arrays from being used as they should be in financial modelling.

    Jeff Robson supported this idea  · 
  2. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jeff Robson commented  · 

    It's possible to do this already if you create range names for each data series and your X-axis labels that are defined as =A5#

    If you set the scope of your range names to the relevant worksheet (NOT workbook, which is the default), you can then define the source for your chart series and X-axis values as =SheetName!RangeName

    So while it's possible, I agree that it's not particularly obvious for the average user and could certainly be much simpler ... so it's still a good suggestion!

  3. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 
  4. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 
  5. 254 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    Jeff Robson supported this idea  · 
  6. 285 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jeff Robson commented  · 

    Totally agree! MMULT is a terrible solution to such a simple problem! Thanks for suggesting this Charles!

    Jeff Robson supported this idea  · 
  7. 481 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Jeff Robson supported this idea  · 
  8. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 
  9. 345 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

    Jeff Robson supported this idea  · 
  10. 643 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 
  11. 174 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Jeff Robson supported this idea  · 
  12. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 
  13. 215 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the post Charles! And thanx to folks for voting. Much appreciated. We definitely understand the ask and are keeping a close eye on this as it is moving up the vote charts .

    As always, please keep upvoting the things you are about most.

    Thanx,
    Prash [MS XL]

    Jeff Robson supported this idea  · 
  14. 632 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeff Robson supported this idea  · 

Feedback and Knowledge Base