Brian Canes
My feedback

84 votes23 comments · Excel for Windows (Desktop Application) » Macros and Addins · Flag idea as inappropriate… · Admin →Brian Canes supported this idea ·

5 votes
An error occurred while saving the comment Brian Canes supported this idea · 
8 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Brian Canes shared this idea ·

17 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Brian Canes commentedAnd 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 · 
8 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Brian Canes shared this idea ·

74 votes14 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
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]An error occurred while saving the comment Brian Canes commentedMaybe 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+1m),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+1m),LINEST({75000;25000},{10;20}^k)) gives 50000
and =SUMPRODUCT(5^(n+1m),LINEST({75000;25000},{10;20}^k)) gives 100000
Powerful
Regards
Brian 
8 votes
An error occurred while saving the comment Brian Canes commentedCombine SaveAs and Close in a CloseAs
Regards
BrianBrian Canes supported this idea ·Brian Canes shared this idea · 
2 votes0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Brian Canes shared this idea ·
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.