Feedback by UserVoice

Brian Canes

My feedback

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

    We’ll send you updates on this idea

    Brian Canes supported this idea  · 
  2. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Brian Canes commented  · 

    And while you look at data validation distinguish between text and numbers by doing the usual excel thing in the dv dropdown by justifying numbers right and text left.

    Brian Canes supported this idea  · 
  3. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brian Canes shared this idea  · 
  4. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brian Canes commented  · 

    And some things need to be done regardless of popularity votes. Like fixing decades old bugs like in DATEDIF, and providing matching names between VBA and WorkBook Functions. And providing certain basic Basic functions like max and min. Really.

    Brian Canes shared this idea  · 
  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brian Canes shared this idea  · 
  6. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brian Canes shared this idea  · 
  7. 56 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, and thanks for showing how you’re using the FORECAST as a workaround. We’ll consider this request along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!

    Best,
    John [MS XL]

    Brian Canes commented  · 

    Maybe have a more general interpolation - Linear, 2nd degree polynomial, third.... and also extrapolation. I have the workaround based on the LINEST function as follows. Define names n, k and m.
    'unY=Sumproduct(unX^(n+1-m),LINEST(y,x^k))
    'where m=TRANSPOSE(ROW(INDIRECT("1:"&(n+1))))
    'where k=TRANSPOSE(ROW(INDIRECT("1:"&n)))
    'x is array or range of known x's
    'ys array or range of known y's
    So n=1 is linear, etc
    'n is number of terms in polynomial 0<n<16
    'unX is unknown x argument
    'unY is unknown y to be determined
    So for n=1 =SUMPRODUCT(15^(n+1-m),LINEST({75000;25000},{10;20}^k)) gives 50000
    and =SUMPRODUCT(5^(n+1-m),LINEST({75000;25000},{10;20}^k)) gives 100000
    Powerful
    Regards
    Brian

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

    We’ll send you updates on this idea

    Brian Canes commented  · 

    Combine SaveAs and Close in a CloseAs
    Regards
    Brian

    Brian Canes supported this idea  · 
    Brian Canes shared this idea  · 
  9. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brian Canes shared this idea  · 

Feedback and Knowledge Base