Feedback by UserVoice

Kenneth Barber

My feedback

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

    More specifically, this is in beta. The LAMBDA function lets you define your own function, and you can give it a name in the Name Manager.

    It would be nice if the LAMBDA function supported variable-length argument lists (e.g. like my XNOR and RMS examples above) and optional arguments, but that can be saved for another suggestion, possibly for another function. The LAMBDA function as it currently is still adds a lot of expressive power to Excel's formula language.

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

    To prevent potential conflicts with the names of future functions, perhaps all UDFs can have the prefix "UDF.". For example, UDF.YESTERDAY().

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

    If Microsoft collects data on commonly used user-defined functions, then they can determine some of the functions that they should add as built-in ones without having to ask people what they would like.

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

    Can you do something like this? I don't have the right version of Excel to test this.
    LET(FACTORIAL,LAMBDA(n,IF(n=0,1,n*FACTORIAL(n - 1))),FACTORIAL)

  5. 283 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  · 

    Frank, the Text To Columns feature produces a static output, cannot be used in formulas, and must be initiated manually. It is good, but it isn't enough. That is why everyone wants a SPLIT/TEXTSPLIT function.

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

    Angela, the 1st argument of VLOOKUP is supposed to be a single value or a reference to a single cell. You have a reference to a whole column in there.

    Also, I would prefer if your comment was relevant to the suggestion that I posted. UserVoice is for suggestions, not questions. Lastly, I don't think that the company that you work for would appreciate you sharing their confidential information like that.

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

    I just learned about ticks. They are also 64-bit but span from the start of the year 1 to the end of the year 9999 and have a precision down to 100 nanoseconds. Since 64-bit Unix time does not support subseconds and Excel does support subseconds, ticks might be a better successor to Excel's serial numbers.

    More about ticks:
    https://docs.microsoft.com/en-us/dotnet/api/system.datetime.ticks?view=netcore-3.1

    An error occurred while saving the comment An error occurred while saving the comment
    Kenneth Barber commented  · 
    Kenneth Barber shared this idea  · 
  8. 11 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  · 
  9. 13 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  · 
  10. 1,148 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

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

    You said "does". Do you mean "does not"?

  11. 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  · 
  12. 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  · 
  13. 1 vote
    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  · 

    The problem with a "full name" button is that there are multiple ways of showing a full name. For example, for me, you can have "Kenneth Barber" or "Barber, Kenneth". Besides, the formulas to derive these are fairly straightforward. If A1 contains the first name and B1 contains the last name, then the formulas are:
    =A1&" "&B1
    =B1&", "&A1

    Thomas K missed the space in his formula.

  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  15. 9 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  · 
  16. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 →
    Kenneth Barber supported this idea  · 
  17. 12 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. 0 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  · 
  19. 14 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. 22 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'd argue that you should never work in an area where people can see your screen. Even if they can't see your user name, they can see your work, which is probably confidential, and from the point of view of the company that you are working for, they would rather have strangers know your name than peek at your work.

← Previous 1 3 4 5 43 44

Feedback and Knowledge Base