Feedback by UserVoice

 

Kenneth Barber

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Deprecate MATCH (make it a Compatibility function)

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber shared this idea  · 

  2. Extend XLOOKUP and XMATCH to return nth matched item/position

    10 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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. RANDARRAY bug in vba

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  4. Function to convert UNIX timestamps to Excel dates

    5 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    Related:

    Add Unix time as a data type:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/38778028-add-64-bit-unix-time-as-a-data-type

    Format Unix time:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10550280-add-support-for-epoch-time-in-date-time-cell-for

    Kenneth Barber supported this idea  · 

  5. Add support for Epoch time in Date & Time cell formatting options

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    Related:

    Convert Unix time to Excel time:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18820879-function-to-convert-unix-timestamps-to-excel-dates

    Add Unix time as a data type:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/38778028-add-64-bit-unix-time-as-a-data-type

  6. World Time Calculator

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

  7. office 365

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

  8. Need power pivot

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Duplicate of:
    https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19568977-add-powerpivot-to-mac-excel

  9. Power Pivot: Make 'Hide from client tools' also hide columns from drill-down

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  10. Google Sheets FILTER function to solve all -IFS suggestions

    32 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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. power bi sources

    7 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  12. Amazon Redshift Connector

    9 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  13. Add Power Query transformation to shift column values

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  14. full anti join (Power Query)

    17 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  15. Make power query in excel = power BI

    29 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  16. Allow users to turn on Beta Connectors in Power Query, similar to Power BI

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 

  17. Incremental data load in PowerPivot through Power Query

    50 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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. add an NZ function in the M language of the Power Query

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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. Allow SUBTOTAL to Use Other Functions Instead of the function_num List

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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. Power Query Truncate function

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    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

1 3 5 … 43 44

Feedback and Knowledge Base

(thinking…)