Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Pull Current Stock Prices and Historical Data Into Excel
Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.
1,148 votesGood news! The STOCKHISTORY function is now available to all Microsoft365 subscribers using Windows, Mac, and Excel for the Web!
If you are unable to see the function you may not have the latest Excel Updates installed on your desktop or are on Semi-Annual Enterprise channel (which releases about 6 months behind current channels). Please send-a-frown or send-a-smile to let us know about your experience (https://aka.ms/ExcelSendAFrown).
Here is an example formula to get you started: =STOCKHISTORY (“MSFT”, “1/1/2021”,“2/1/2021”)
More details can be read on: https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338
This wonderful feature has been a long time in the making, and we are hoping this functionality helps enhance your decision making experiences using Excel.
—Kaycee Reineke
Excel PM -
Make a simple safer version of VLOOKUP and INDEX MATCH
The majority of Excel users use VLOOKUP to get exact matches from a row or column, It would be good if they all used INDEX MATCH but it's more complex so how about this simpler version for the masses.
=GETMATCH(ReferenceToMatch, MatchColumn/Row, GetColumn/Row, Optional Value if no match)
If seen a few other references to updating VLOOKUPS and there are lots of opportunities, but it would be good to address the simple most widely used issue first.
742 votesAnd that’s a wrap! XLOOKUP has been released to production. All Office 365 users in the Monthly Channel should have it in their Excel now. Users in the Semi-Annual Channel should have it starting in July.
You can read about XLOOKUP here: https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376
Thanks for voting! Make sure you move your votes to another request.
Joe McDaid
-
Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese
That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.
🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻
307 votesThanks everyone! We updated the Portuguese translation of XLOOKUP based on your feedback. [Joe McDaid – Excel]
-
Release XLOOKUP to the world!
Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!
193 votesXLOOKUP is now available to all users of modern Excel across all endpoints. We deployed XLOOKUP to the last group of users (Semi-Annual channel) in July 2020.
XLOOKUP will not be available in Excel 2019 and Excel 2016. These are point in time versions of Excel that predate the release of XLOOKUP.
[Joe McDaid – Excel PM]
-
Add an If_NA optional sixth argument to XLOOKUP
The new XLOOKUP function introduced on August 28 2019 is awesome - exact match by default, the ability to return several columns at once, and search from bottom of data. But one thing would make it better - an optional sixth IfNA argument to provide an answer in case nothing is found.
One of the benefits of XLOOKUP is to eliminate the need to nest MATCH inside of INDEX. If you are trying to reduce the number of functions this would be a low-impact way of eliminating nesting XLOOKUP inside of IFNA.
For me, the main argument is that…108 votesThanks for the suggestions folks! We’ve added [if_not_found] as the 4th argument to XLOOKUP. The thinking is as follows:
It’s a reasonably common use case
The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.
- Joe McDaid [Excel] -
Improve the Concatenate Function
Make Concatenate to Work with Range of Cells / Arrays rather than 1 cell separated by Comas
=CONCATENATE(Array,Seperator)
The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}
or70 votesUpdate – 2016-03-07
Hi All,
Just wanted to let you know that we’ve completed adding new =CONCAT and =TEXTJOIN functions to Excel 2016 (as part of Office 365 – builds 16.0.6528 and later) that should do what’s been requested here. You can read more about it on our blog:
Cheers,
Dan [MS] -
Please add MAXIF and MINIF
It would just be so useful to have this. Thanks!
40 votes2016-04-19
Hello all,
Just wanted to let you know that we’ve released MAXIFS and MINIFS to Excel as part of Office 365. If you’re a subscriber you should already have (or see soon) these functions in your arsenal.
Cheers,
Dan [MS]2015-11 ========
Hi there,Great news – we’re working on this! Actually, we’re working on MAXIFS and MINIFS – even better :-)
Cheers,
Dan [MS] -
38 votes
We’re happy to say that the UNIQUE function is available for O365 subscribers. Please see this article for more information – https://support.office.com/article/UNIQUE-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
-
Add a select case function
=Selectcase(A1>89,"A",A1>79,"B",>69,"C",A1>"59,"D","F")
7 votesGreat news – we’ve introduced the SWITCH function to Office 365 subscribers. If you update today, Aug 19, 2016, (if you haven’t already), you should now have this in your arsenal.
https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e
Cheers,
Dan [MS]Updating the status here – we’ve actually got something in the works that should be out soon. Stay tuned!
Best,
John [MS XL] -
I want "JOIN(range, delimiter)" function
To concatenate multiple cells, I can use CONCATENATE() function or simply join by "&". But as a range, there seems to be no handy function.
I want a "JOIN()" function.
USAGE:
JOIN(<RANGE>, <DELIMITER>)
ie, for joining from A1 cell to AX1 cell with a delimiter ",", =JOIN(A1:AX1, ",")5 votesYou can do this with the TEXTJOIN function, which was added to O365 Excel several years ago.
-
Combine RAND and RANDBETWEEN
RAND returns a real number between 0 and 1.
RANDBETWEEN returns an integer between 2 user-chosen numbers.We should have a single function that lets you choose the number range and lets you choose whether the value returned is an integer or real number.
To do this, either modify RAND() to take 3 optional parameters or add an optional "number set" parameter to RANDBETWEEN. The function that is not modified becomes a compatibility function.
2 votesPlease try the new RANDARRAY function, which has more options than RAND and RANDBETWEEN.
-
Kill nested IFs
What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)
1 voteGive our new IFS and SWITCH functions a go – they are exactly what you’re looking for.
Cheers,
Dan [MS] -
Absolute Reference Shortcut
Really simple. Pretty much in all my data analysis involves absolute references and relative references. For a formula I enter, I have to go through and manually type in the $ symbols to lock those references, which can be cumbersome when I have 15 or so references to take care of. What I suggest is a shortcut key e.g. ctrl + click/alt + click where by clicking the cell in the formula using this combination will convert it to an absolute reference.
1 voteGreat news, we have this in Excel already. as you are authoring a formula, when you select a cell/range, you can press F4 to toggle the “absolute-ness” of the reference.
cheers,
dan [MS]
- Don't see your idea?