Please extend FIND and SEARCH Function to search from right to left. Also if possible add a function to reverse string.

Thee 2 important and basic functions are missing

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

Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.

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

Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.

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.

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.

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

There needs to be an GETHYPERLINK function that lets you reference the hyperlink that is alreday associated with a cell.

For example if the contents of cell A1 =HYPERLINK("https://www.microsoft.com","Microsoft Home Page")

Then there needs to be a way to put in cell B1 =GETHYPERLINK(A1) which would return "https://www.microsoft.com" without needing to do it in VBA.

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.

For example, A6#: {2, 3, 5} and B6#: {A, B, C}

All the combinations of {2 A, 3 A, 5 A, 2 B, 3 B, 5 B, 2 C, 3 C, 5 C} can be returned in a 6 x 2 dynamic array.

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!!!!!

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!

Add Translate Function as like as google sheet googletranslate function. it is very applicable if you add it in Mirosoft Excel. Thank you.

Can Microsoft pay us for good suggestions for improving Ms Excel usability?

Support of dynamic array formulas in tables

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.

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?