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. ## Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)

Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)

Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## dear Microsofts! I have Grafting array

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## Convert Dynamic Arrays into Tables

The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Add a MONTHDIF function

The formula should work like the YEARFRAC function. It should calculate partial months on either end of the dates. So starting 1/15/20 should calculate as 16/31 days or 0.516.. months, and ending at 6/5/20 should calculate as 25/30 day or 0.8333.. months. Currently, I have to use a ridiculously long formula to achieve this.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Need Stock Data Type Functionality on Office Pro Plus 2016

Dear Microsoft Team :( ,

Did you know there is a Stock Function in all your desktop versions of office products and did you know it does not work?

I am wondering if you will ever get it to work? It's not that you are short on funds to add that additional line of script to pull the free data from from exchange.

If you still don't want to give it as a free update to your customers, you can sell it as a chargeable add-in.

If you don't want to do either, please add a pop-up saying "YOU WERE…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## COUNTIF, SUMIF............etc. based on cell color

If Excel allow us to use cell color as function criteria, it would be wonderful.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## DECODEURL function

Currently, The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.

There needs to be a DECODEURL function that does the reverse, replacing the percentage symbol (%) and a hexadecimal number with the appropriate non-alphanumeric characters.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## DONT'T CHANGE MY FORMULA!!!!!!!

How about keeping the formula intact, returning a #REF result and NOT editing the formula with a #REF comment. This stupid idea prevents one from following the formula back and evaluating what the error is, or what cell it's referencing. Who ever thought of doing this should have some training! If one receives a spreadsheet developed by someone else, they may not know how the formulas work/reference, but leaving the formula intact gives the opportunity to understand what the result should be. CHANGING the formula should NEVER be an automatic option by the software!!!!!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## Formula to get valueout of merged cells

lets say we have merged cells A1:D10, when I do =A1 then I get the value, but when I do =C3 then I get nothing becuase the value is not stored the. But if there would be function, lets say =GetMergedValue(C3) so it would lookup the merged area and gets the value, this would be great!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Date picker button for excel in offfice 365 for Windows 10 64 bit

I am so surprised that there is no Date picker function available in Excel 365. I see that this function existed and has been removed. this makes no sense to me what so ever. This is what has been pushing me away from Microsoft. This is why I have stopped using One note ( due to feature removals) and seek other options as you just cant rely on such thing.

I feel less protective of Windows/ MS at home and hence Apple and Google devices have started replacing MS specially by Kids. Surface pro 4 was highly disappointing. So now…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Support of dynamic array formulas in tables

Support of dynamic array formulas in tables

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

We’ll send you updates on this idea

13. ## Formula to return multiple values from LookUp function

We need a simple formula that can return all the values from data source based on a lookup. Vlookup, Xlookup return only first matching value and don't check further.

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

We’ll send you updates on this idea

14. ## Add Non-Repeating Option to RANDARRAY

Currently it is difficult to get non-repeating random numbers in Excel. Can we add an option to RANDARRAY to force it to only generate unique random numbers?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## vlookup case sensitive

very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Allow lookup functions to spill in two dimension

Currently Vlookup, Xlookup, Lookup and Index function is able to produce a spilled array only across one dimension (i.e. row or column).

So, if I give a formula like =Vlookup(J4#,Table1,{2,3},0), it spills only across rows and does not spill across column. This limitation exists with every other function in the lookup family.

If these functions can be made to spill across both the dimensions, we can completely avoid copy pasting in MS Excel.

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

We’ll send you updates on this idea

17. ## Disable the "SPILL!" error function completely

Disable the SPILL! error fucntion/code completely, it is garbage and wrongfully tags formulas with SPILL! Having to go in and change formula syntax to satisfy this random error is ridiculous.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.

Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.

For that matter either give Office 2019 Pro Plus users the option to migrate to Office 365 at a reduced cost or provide the nice new office 365 functions to Office 2019 Pro Plus users

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Extend XLOOKUP and XMATCH to return nth matched item/position

INDEX, MATCH and other variants return the FIRST value that matches the given criterion. Extend the functions (especially the new XLOOKUP/XMATCH functions) so that the formulae return the nth matching item or position

Extend XLOOKUP and XMATCH to return nth matched item/position

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Immediately color-code cell references upon selection

When we edit a cell by double-clicking it or hitting F2, we get a very helpful color-coding of the cells it references. Why can't we just get this color-coding immediately upon selecting the cell? That way we could easily click or arrow-key through several cells and quickly see what they're referencing, rather than having to squint and find "Column G.... Row 11....., Column K .... Row 15....", etc.

See attached GIF animations demonstrating the current behavior versus what I'm proposing.