Feedback by UserVoice

Kenneth Barber

My feedback

  1. 18 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
  2. 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  · 
  3. 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  · 

    I thought that the world is trying to move away from ActiveX?

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

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    I thought that the default formatting changed only going from Office 2003 to Office 2007, and that was because some programs used Arial as the default font and others used Times New Roman. Now, it is Calibri for all Office programs.

  5. 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
    Kenneth Barber commented  · 

    Office 2016, Office 2019, etc. are the stable releases. Office 365 is the one that keeps on getting updated.

  6. 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
    Kenneth Barber commented  · 

    In response to John, the RAND column is used only to sort the data randomly, and this does not require unique values. You can assign a unique number to each row after you randomly sort it.

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    In what case is such a feature much better than the longer way of making a random number column using the RAND function and sorting by that?

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

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    I'm not sure what I was thinking when I wrote the 1st bullet point. Only BITRSHIFT would need a signedness argument.

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

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

    1 comment  ·  Excel for the web  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    The dot product function in Excel is SUMPRODUCT.

    Having a dedicated cross product function would be pretty nice, especially now that Excel supports dynamic arrays.

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

    2 comments  ·  Excel for Mac  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  11. 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

    1 comment  ·  Excel for Mac  ·  Flag idea as inappropriate…  ·  Admin →
    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

    4 comments  ·  Excel for Mac  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber supported this idea  · 
  13. 98 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. 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  · 
  15. 21 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  · 

    One of the problems with FIND and SEARCH is that if you are using them in the condition of IF, you need to use ISNUMBER or ISERROR to detect if the substring was found. I agree that while the COUNTIF method works, it is a bit unintuitive and you need to worry about escaping any wildcards that may appear in the searched string.

    What we really need is something like InStr from VBA. It also returns the position of a substring, but when the substring cannot be found, it returns 0 instead of an error. This would allow us to also use it like CONTAINS and write IF(INSTR(),"found","not found"), which is ultimately what we want. We can't go IF(FIND(),,) because the string is not found, the IF function will return the error returned by FIND.

    The problem could also be solved by adding an additional argument to FIND and SEARCH that represents the value that should be returned if the substring cannot be found. The FIND and SEARCH functions in DAX (Power Pivot) are already like this. Then we can use FIND(,,,0) to simulate InStr.

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

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Use Excel tables (available on the Insert tab) and you'll never have to speak in terms of "column AB" again. With Excel tables, you give names to your columns, and you can refer to those instead.

  17. 14 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 would argue that 0 should be reserved for "no sorting". A spreadsheet might be set up so that the user chooses the sort order, and having a "no sorting" option would make writing this formula a bit easier.

  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

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

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    MATCH returns only single number. It wouldn't make sense for it to work on a 2D range.

  20. 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 shared this idea  · 

Feedback and Knowledge Base