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  · 

    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.

  2. 41 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 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.

  3. 240 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'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).

  4. 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  · 

    There 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 INDEX-MATCH to look up your notes and display them beside your PivotTable.

1 2 40 41 42 44 Next →

Feedback and Knowledge Base