Kenneth Barber
My feedback

8 votes3 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment 
41 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
We’re always looking for ways to make formulas smaller and easier – thanks for the suggestion! We’ll prioritize this according to the number of votes, so keep voting if you want to see this get done sooner!
Thanks,
John [MS XL]An error occurred while saving the comment Kenneth Barber commentedI think that this is why they added the IFNA function.
My bone to pick with VLOOKUP and HLOOKUP is this. The ideal format for VLOOKUP is this: VLOOKUP("value",A:C,COLUMNS(A:C),FALSE). If column A should move to the right of column C, then even if you move it back, the references are broken, hence why people like me use INDEX(B:B,MATCH("value",A:A,0)).
VLOOKUP and HLOOKUP should also have an option to search in data sorted in descending order, much like what MATCH has.

240 votes13 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion figboot. As always, we’ll prioritize this according to the number of votes it gets, so please be sure to vote it up if you want to see it done sooner.
Thanks
John [MS XL]An error occurred while saving the comment Kenneth Barber commentedI'll support this suggestion by listing some workarounds that I do. Maybe they will help you in the meantime.
One workaround to shorten your formulas is this. Instead of IF(ISBLANK(big formula),"blank",big formula), keep your big formula in a helper column, so then your formula becomes IF(ISBLANK(A1),"blank",A1).
For a workaround for IFZERO, if your formula is IF(denominator=0,0,numerator/denominator), change it to IFERROR(numerator/denominator,0).
If your formula is IF(big formula=0,0,big formula), and the big formula is numeric (i.e. not text), then you can go IFERROR(big formula^1^1,0).

7 votes2 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Kenneth Barber commentedThere is a slight problem with this. If you have multiple columns of values in your PivotTable, then the note becomes attached to at least 2 source values. Then where does it get stored? Is it repeated in the source table? One work around would be to create a new table with every row heading that your table has and put the notes in there. Then use VLOOKUP or INDEXMATCH to look up your notes and display them beside your PivotTable.
If you are not doing date/numeric operations on your dates, then you could use the UPPER(TEXT(your date,"mmm")) in a new column. However, I still think that your suggestion is good.