Kenneth Barber
My feedback
-
8 votes
An error occurred while saving the comment -
14 votes
An error occurred while saving the comment Kenneth Barber commented
I know what you mean. Sometimes, to do the OR condition for SUMIFS, I have multiple SUMIFS like this:
=SUMIFS()
+SUMIFS()But then I remember that I should forget the alignment and write this instead to show that the line is incomplete:
=SUMIFS()+
SUMIFS() -
73 votesAccepting Votes · 11 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
The workaround is to fill the "nulls" with #N/A by using the NA function.
-
3 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
So basically Accounting formatting without the $.
-
3 votes3 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
You might want to say what the flaws are...
-
7 votes2 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
It's in View tab, Macros, View Macros, Options. The information is there, but all of the shortcuts are never all in the same place.
-
8 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
I know what you mean. If I know that I'm going to heavily modify a file, I make a backup so that I know what #REF! used to be, but it's a pain.
Your post goes nicely with this one:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10606047-protect-me-from-ref-ambushes -
3 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
They could just move the Options into their own tab. There are so many other settings that would be nice to change easily, like hiding sheet tabs.
-
2 votes2 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
If you need more choices in terms of graphs, you can try GraphPad Prism for now. It's a graphing program for researchers. Also, you make reference to figures. Where are they?
For those who don't know German or couldn't be bothered to copy and paste this into Google Translate, this suggestion is about logarithmic axes.
-
136 votes18 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
I should mention that the current workaround is
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)Not pretty. I also agree that it should not be called ShtName. SHEETNAME is more appropriate.
-
14 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
6 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
I'm assuming that you've tried filtering for your rows to delete and then deleting those and then unfiltering, yes?
Also, by "function", you mean "feature". In the Excel context, "function" usually means "mathematical function".
-
57 votes7 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
That would be lovely. When we use the Windows APIs, we kill the portability of our workbooks, since Mac computers do not have the Windows APIs. The burden should be on Microsoft to make their Windows and Mac versions of Excel read keys differently, not on us.
-
6 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
The current workaround for the new capability is to do this: IF(VLOOKUP("value",A:A,1,TRUE)="value",VLOOKUP("value",A:C,COLUMNS(A:C),TRUE),NA()).
The first VLOOKUP checks if the sorted match is actually a match. The second VLOOKUP is your regular VLOOKUP (3 changed to COLUMNS(A:C) for robustness).
-
24 votes5 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
You can always customize your Ribbon. If your students are wasting time not knowing about Clear All, maybe you should, um... teach them!
For me, the time waster in school was creating a graph just to get the line of best fit equation to predict a single value. The better alternative was of course FORECAST.
-
165 votes42 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
This is a great suggestion and we appreciate all the comments. Please vote if you like it and encourage others to support this idea. We’ll keep tracking the voting.
There’s an add-in that can help you translate function names and formulas. Please see this article for more information – https://support.microsoft.com/office/funktionen%C3%BCbersetzer-f%C3%BCr-excel-f262d0c0-991c-485b-89b6-32cc8d326889
An error occurred while saving the comment Kenneth Barber commented
You could make the same argument for programming languages too. In the Excel context, this means VBA.
-
11 votes7 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
You could just move the sheets beside each other and click between them. You might also want to look into combining similar sheets to reduce the number of sheets.
-
31 votes12 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
Automatic indentation should be an option alongside the current "no indentation".
-
10 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
Here's an alternative wording: Make a version of VLOOKUP that returns an array of all matches so then we can use INDEX to choose the one that we want.
-
7 votes2 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commented
I think that linking to a demo workbook would help make your case stronger.
You might want to think about why you need to Save As so often. If it's for version control, Excel already offers that. If you are making daily files, consider keeping a single file with everything in it. It will be easier to analyze data over time that way.