Kenneth Barber
My feedback
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber shared this idea ·
-
10 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
3 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
5 votes1 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-typeFormat Unix time:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10550280-add-support-for-epoch-time-in-date-time-cell-forKenneth Barber supported this idea ·
-
6 votes1 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-datesAdd 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 -
2 votes
-
3 votes
-
3 votes1 comment · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
6 votes1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
32 votes7 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-filtKenneth 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-syntaxAn 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 ·
-
7 votes1 comment · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
9 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
2 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
17 votes3 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
29 votes2 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
4 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Kenneth Barber supported this idea ·
-
50 votes5 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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 TeamKenneth Barber supported this idea ·
-
1 vote1 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.
-
3 votes2 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.
-
6 votes
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
Use FILTER to return an array of matches, and then use INDEX on the result to get the Nth item.