Brian Canes
My feedback

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

4 votesBrian Canes supported this idea ·

7 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 →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 · 
9 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Brian Canes shared this idea ·

60 votes11 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]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 votesBrian Canes commented
Combine 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.