Feedback by UserVoice

# 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.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## Comparison chaining (0 < x <= 1) or BETWEEN function

One of the early but forgotten disappointments of any Excel user is that you can't do this:

0 < A1 <= 1

You have to break it up like this:

AND(A1>0,A1<=1)

otherwise Excel will evaluate 0 < A1 and check if that is <= 1.

Since we rarely want this case, why not interpret 0 < A1 <= 1 as the user intended? It would make formulas more readable and avoid repetition. Of course, this can be extended to all comparison operators (<, >, <>, <=, >=, =) and for an arbitrary number of them in a row (e.g. 1…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Sequence function Numeric Run

Instead of futzing around with things like ROW(INDIRECT("1:"&Len(A1))) and Column and Transpose in order to construct certain array formulas which need runs like 1,2,3,4,...., provide a Seq array function.
Seq(from,to[,step][,Horiz/Vert]). Also make it imply an array function like does sumproduct.
REgards
BRian

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## Expand the MATCH function - allow range being searched to be 2-dimensional.

Expand the the MATCH function capability to allow the second argument to refer to a two-dimensional range, instead of restricting it to data in a single column or data in a single row.
Microsoft's documentation of the MATCH function (via Excel Help) does not mention this restriction but simply refers to the "range of cells being searched" as if it could be any range.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## vlookup for 2nd, 3rd, etc occurrance

How about something like =VLOOKUP(lookupvalue,tablearray,colindexnum,range_lookup,occurrance) like =VLOOKUP(123,A1:B100,2,FALSE,3) where the 3 means to return the 3rd occurrance of the lookup value. Of course, #N/A if there isn't one.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Array Formula - allow us to type the curly braces instead of CSE (and make them persistent when i edit formula!)

currently we have to use Ctrl-Shift-Enter. What an odd concept. Please make array formulas easy to enter just like any other formula. Either let us type in the curly braces, or add something like ARRAYFORMULA(......). At least, PLEASE make the array formula persistent. Currently if I (or any other user) even looks at the formula, they can easily break it just by pressing enter.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Network functions, like ping() or nslookup()

Handy if you have a column of hostnames or IP addresses.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Interesting idea, thanks for the suggestion. I’d be interested to know if there are other functions in this area that people also want to see. I’ll check back soon to see how many votes this is getting, so if you like the idea be sure to vote for it.

Cheers,
John [MX XL]

7. ## VLOOKUP with exact match and sorted data

VLOOKUP formulas where you want an exact match are often accused of being slow, especially when the lookup table has a large number of rows and columns. And if you have a lot of VLOOKUP formulas, changing a value in the lookup table can result in an annoying delay while all the VLOOKUP formulas using that table recalculate.

In many cases, the user would be willing to sort the lookup table by the first column--provided that led to a significant improvement in recalc time because of a binary search. The problem is that setting the fourth VLOOKUP parameter to TRUE…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Formula autocomplete - select with Spacebar

Excel's autocomplete on formulae is nice, except that there doesn't appear to be a shortcut key to actually accept the suggested formula. The only way to select it afaics is to pick up the mouse and click on it, which is annoying when your hands are on the keyboard.

Apologies if a shortcut key for this already exists, though I've never found it and I also checked here:
https://support.office.com/en-us/article/Use-Formula-AutoComplete-6d13daa5-e003-4431-abab-9edef51fae6b

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Cortana should learn excel syntax so that I don't have to

Cortana should learn excel syntax so that I don't have to. Pretty simple, for users that don't want to learn functions such as left/right, they should simply be able to say "Cortana, take the last 3digits off that column and put them in the next column" "Make me a pie chart with the colors red white and blue"

(2015-11-05 Dan [MS] - added to Formulas and Functions category)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the post. As always, we’ll be looking at ideas in priority order according to the number of votes things have. So please keep voting for things you want to see done sooner!

Thanks
John [MS XL]

10. ## In EXCEL 2010 with all updates available installed, the polynomial curve fit otion only works for second power equations no matter the input

in EXCEL 2010 (with all updates installed) the polynomial curve fit option only works for second power equations even if you tell it to fit with higher power polynomials. This used to work perfectly but one of the recent updates must have affected this

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Suggest formula simplifications to the user

For those without a strong Excel, math, and/or computer science background, formulas can be much more complicated than they need to be. To help them along, Excel could suggest simplifications to commonly used simplifiable expressions. It would be like a spell checker, but for logic.

Here are some simplifications that I've done over the years:
IF(A1=1,"",IF(A1<>1,"s","error")) has an unreachable part "error" and becomes IF(A1=1,"","s").
NOT(A1<B1) becomes A1>=B1.
IF(A1<0,0,A1) becomes MAX(A1,0).
DATE(YEAR(A1),MONTH(A1)+1,1) becomes EDATE(A1,1).
SUMIFS(,,"="&A1) becomes SUMIFS(,,A1).
(A1B1)+C1 becomes A1B1+C1.
...
and so on.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## vlookup should treat the lookup value as it APPEARS

If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Daylight savings time

We should have functions that allow for the conversion of non-DST time to DST and vice versa. To determine the location parameter for DST rules, have a map pop up so that you can choose where you are.

To give you an idea of how complicated this can be from a user's perspective, this is the formula that I use to convert non-DST to DST:

A1+TIME(ABS(A1+WEEKDAY(DATE(B1,3,7))-DATE(B1,7,12)-1/12)<=119,0,0)

where A1 holds the datetime and B1 holds YEAR(A1). This is the shortest formula that I've come across/come up with, and it only applies to Canada, and its derivation is difficult. Surely Excel can…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Function to only use every xth-row or column in another function

Function to only use every xth-row or column in another function

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## Add a Switch Reference button to Ribbon

Many know the F4 is used with authoring a function. However it needs to be memorized. please create a button on the ribbon to switch between types of referencing.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Automatic update of text value in textboxes linked to cells and maintain the format of the text in textbox

Textboxes can be linked to cells for values / texts. But, if it is a dynamic connection, in the sense, if the value in the cell changes based on formulae, the textbox takes the first given value. Then, on, even if the cell value changes, the value in the text box does not change in the current scenario. Everytime, we need to press F2 and enter for the formula / datalink in the textbox to get updated. But after that, If we have to manually update the format of the text in the textbox. If both these activities can happen…

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Implement a shortcut switch to R1C1 notation

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Add an IN() function to check for existence of a value

Right now, I often use formulas like this:

``````=IF(COUNTIF(&quot;A&quot;, myRange)&gt;0, ..., ...)
``````

It's be handy to be able to just use:

``````=IF(IN(&quot;A&quot;, myRange), ..., ...)
``````

This could also help with formulas where a number of different criteria are allowed:

``````=SUMIFS(B:B, A:A, &quot;2016&quot;) + SUMIFS(B:B, A:A, &quot;2013&quot;) + SUMIFS(B:B, A:A, &quot;2010&quot;)
``````

becomes

``````=SUMIFS(B:B, A:A, IN(A2, &quot;2016&quot;, &quot;2013&quot;, &quot;2010&quot;))
``````

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Lets users set exponential smoothing beta and alpha

In some fields, such as supply chain management, it helps for analysts to be able to set their own alpha and beta values when using the new exponential smoothing functions. I don't think it's necessary to build it into the Forecast Sheets.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Add a funciton to search in a string from the end (INSTRREV)

(2016-03-08 Dan [MS] - updated title to include INSTRREV, when merging in duplicate idea)