Feedback by UserVoice

Kenneth Barber

My feedback

  1. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    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.

  2. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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()

  3. 73 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  4. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    So basically Accounting formatting without the $.

  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    You might want to say what the flaws are...

  6. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  7. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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

  8. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  9. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  10. 136 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  11. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  12. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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".

  13. 57 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  14. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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).

  15. 24 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  16. 165 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  17. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  18. 31 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Automatic indentation should be an option alongside the current "no indentation".

  19. 10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  20. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    I think that linking to a demo workbook would help make your case stronger.

Feedback and Knowledge Base