Feedback by UserVoice

Kenneth Barber

My feedback

  1. 67 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 even less excuse to not have this function now that array formulas are getting even easier thanks to dynamic arrays.

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

    Charles, we already have the JOIN functionality with TEXTJOIN. All we need is SPLIT.

    An error occurred while saving the comment An error occurred while saving the comment
    Kenneth Barber commented  · 

    And it's already supported in FormulaDesk...

    Kenneth Barber shared this idea  · 
  2. 90 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  3. 461 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  6. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 

    Gareth, your approach works, but I still feel like we shouldn't need a function to remove volatility. But I guess you make a good point. It's not just TODAY that shouldn't be volatile; it's basically every volatile function that shouldn't be volatile and cells containing volatile functions shouldn't start a recalculation chain unless they actually change.

    Kenneth Barber shared this idea  · 
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber shared this idea  · 
  8. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  9. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment An error occurred while saving the comment
    Kenneth Barber commented  · 
    Kenneth Barber shared this idea  · 
  11. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  12. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 →
  13. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  14. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  15. 31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  16. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  17. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  18. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  19. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  20. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
← Previous 1 3 4 5 43 44

Feedback and Knowledge Base