Could you make the MODE function work for text?
Currently you have to do a crazy index and lookup thing, which could all be made so much easier if mode worked for text. i.e., if you have MODE("a", "b", "c", "a") you would get "a".7 votes
Interesting idea – thanks for the suggestion Tomiam8. We’ll consider this and prioritize by vote, so please keep voting if you want to see the priority raised!
John [MS XL]
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).
(A1*B1)+C1 becomes A1*B1+C1.
and so on.2 votes
Sorting based on the order of entries in a Custom List works OK, but if you send the file to others, they need to set up the Custom List as well.
Make the entire process more flexible and faster by allowing the order of sorting to be based on worksheet cells just to the right (or anywhere else) of the list you're about to sort rather than requiring a reference to a Custom List?1 vote
If a table has one or some more filter criterias you got a list of results. But when you copy this list or have a look at the result, you cannot see, which criterias had been set.
It would be great, if you could copy the list of criterias to a range or have a look to all criterias in an overview like the Name Manager.
Thanks for this opportunity to give feedback to you.
Andreas (London)1 vote
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!3 votes
Remove lines when Freeze Panes is on. Put a small indicator top right of Ribbon or similar.3 votes
Currently, when we go to use functions in the Name Manager or to define a calculated field, absolutely nothing pops up. We just have to know what we are typing. This is very unlike cells, which not only have IntelliSense, but there is also an option to construct formulas using the Function Arguments window.1 vote
With large Excel models, when a variable is linked to Form controls such as a sliders (e.g. for a dashboard), the slider can start moving of its own accord even if the user has only clicked once. Please can you fix this bug.6 votes
It is not possible to access a point's values or range from VBA. We have to parse the point's name (S3P14), the go to the third series' 14th cell in the x values range to access the points' value or range.
It is also not possible to access a series' legend entry as a property from VBA.
There are many examples of this kind of "incompleteness" of the VBA charting object model. It would be great if these related objects could be exposed, to simplify code.8 votes
Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.
Could you further comment on the other areas which you feel are incomplete?
Tables are really great for managing data. Sometime It would be useful if the table could have the rows as the header rather than the columns. e.g. a regular excel table but transposed.3 votes
It would be good to have Cell Tags, invisible tags which are assigned a colour so that when you click on a cell it fires an event and you can perform a function like drill down to a page, view a subset etc any event really.1 vote
It would be very helpful if Excel could record the total editing time spent working on a spreadsheet. Or if Excel could better still, automatically log each time period spent editing a spreadsheet. Helps when billing customers and giving volunteer hours as I do a lot with Excel.2 votes
When I right click on a tab and choose the "Move or Copy..." option, then check the box to "Create a copy" it would be nice if the was an area underneath the check box to enter the number of copies that I want. Then I wouldn't have to do this ten times if I want ten copies of a sheet.3 votes
Have a tool that allows you to see what cells (or ranges) are changed when a given cell is altered - i.e., the entire dependency tree rooted at that cell. It is much easier than trying to manually do trace precedents etc.1 vote
1) Bug: when panes are frozen, in the moment when filter is applied the sheet is being violently scrolled horizontally in a random direction, hiding the active column.
Please do not scroll on filter application.
2) Missing functionality: The filter popup list can be re-sized to show more or wider items. Unfortunately the size of the popup is not remembered on the next pop.
Many thanks!4 votes
Right now it is limited to Bing, but I'd like to be able to have it query other data sources.
This was an idea that came out of the Excel User Group Meetup.1 vote
It could be something like "show me the highest grossing month last year" and maybe have Excel filter a table.1 vote
If I give an Excel-table a name, then I can use the Go-To function to find it. Why can’t I find named Pivot tables in the same list?4 votes
It is observed that the pivot "calculated item" feature has two serious drawbacks:
(1) The calculation takes a long, long time compared to "calculated field" feature.
(2) The calculated numbers generated via "calculated item" on the pivot table can be altered or defaced which does not happen when "calculated field" feature is used.
The above drawbacks render the use of "calculated item" in pivots unusable. Can we address these?3 votes
Enabling filtering on two columns of a worksheet with around 15 columns and about 450,000 rows causes the scroll bar to break. The scroll bar reduces in size to the filtered range but it cannot be used to scroll to the bottom of the worksheet. The only way to get to the bottom is to click in a cell and arrow down or use page down. This makes it very difficult to select the desired range since page down moves the currently selected cell preventing a shift-click from adding cells off-screen to the selection. If I can open a csv file of this size, I should be able to filter the results.
Enabling filtering on two columns of a worksheet with around 15 columns and about 450,000 rows causes the scroll bar to break. The scroll bar reduces in size to the filtered range but it cannot be used to scroll to the bottom of the worksheet. The only way to get to the bottom is to click in a cell and arrow down or use page down. This makes it very difficult to select the desired range since page down moves the currently selected cell preventing a shift-click from adding cells off-screen to the selection. If I can open a csv…1 vote
- Don't see your idea?