Feedback by UserVoice

Kenneth Barber

My feedback

  1. 1 vote

    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

    Kenneth Barber shared this idea  · 
  2. 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  · 

    Use FILTER to return an array of matches, and then use INDEX on the result to get the Nth item.

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

    Kenneth Barber supported this idea  · 
  4. 5 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 supported this idea  · 
  5. 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
  6. 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

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

    0 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  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
  9. 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

    Kenneth Barber supported this idea  · 
  10. 32 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 don't know about everyone else who voted for this, but even though Excel doesn't have a FILTER function exactly like the one in Google Sheets, I am happy with the FILTER function that did get introduced to Excel, and I am willing to call this suggestion completed.

    The next issue is how to handle complex conditions. This is what this suggestion is for:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/39976513-add-and-and-or-operators-good-for-use-in-the-filt

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    The link below shows how to do the OR condition in FILTER, so we don't need the database functions (e.g. DSUM) either.
    http://webapps.stackexchange.com/questions/42428/google-spreadsheet-filtercondition-or-condition-syntax

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Hi Corey,

    Here are some additional points about FILTER that I think help my case:
    1. SUBTOTAL is a function used by the general public for summarizing filtered results. The concept of separate filtration and aggregation would thus be familiar.
    2. It's not just the -IFS variants. Some aggregate functions have -A variants as well. If all -IFS and -A variants were implemented, the function list would be triple what it needs to be.
    3. FILTER does not require string concatenation for comparison operators. Comparison: SUMIFS(A:A,B:B,">"&C1) versus SUM(FILTER(A:A,B:B>C1)).
    4. FILTER would provide compatibility with Google Sheets spreadsheets that use FILTER.
    5. The versatility of FILTER should make up for the fact that it needs to be paired with another function to be useful (so I'd like to think).

    About your comment on VLOOKUP, it is not a function to look to for simplicity or robustness, only familiarity.
    1. Why do you need to specify a table_array as opposed to just the 1st column? What is an approximate match? Does the col_index_num start at 0 or 1? These are all questions that I had when trying to learn VLOOKUP.
    2. To search for multiple criteria using VLOOKUP, you need to do something like VLOOKUP(A1&B1,C:D,2,FALSE). To guard against column insertions in your table_array, you need to use VLOOKUP(A1,B:C,COLUMNS(B:C),FALSE). These are much tricker than the PRODUCT(FILTER()) combination.
    3. There are many suggested improvements for VLOOKUP here on Excel UserVoice. People don't even like VLOOKUP.

    I'd like to think that FILTER would have, at worst, an implementation story similar to the Microsoft Office Ribbon or the Facebook Timeline. That is, the initial negative reaction turns into understanding and agreement.

    Kenneth Barber shared this idea  · 
  11. 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

    Kenneth Barber supported this idea  · 
  12. 9 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

    Kenneth Barber supported this idea  · 
  13. 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

    Kenneth Barber supported this idea  · 
  14. 17 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

    Kenneth Barber supported this idea  · 
  15. 29 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

    Kenneth Barber supported this idea  · 
  16. 4 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

    Kenneth Barber supported this idea  · 
  17. 50 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

    Thank you for taking your time to suggest and vote for this feature! That’s a great suggestion, but unfortunately we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Kenneth Barber supported this idea  · 
  18. 1 vote

    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 already Table.ReplaceValue, which can replace any given value, not just null, with something else.

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

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    SUBTOTAL has been superseded by AGGREGATE. I agree that we should be able to pass functions to other functions.

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

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Use Number.RoundTowardZero to truncate numbers.
    https://docs.microsoft.com/en-us/powerquery-m/number-roundtowardzero

Feedback and Knowledge Base