Feedback by UserVoice

Kenneth Barber

My feedback

  1. 10 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  · 
  2. 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  · 
  3. 1,101 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"?

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

    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.

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

    We’ll send you updates on this idea

  8. 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  · 
  9. 26 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  · 
  10. 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  · 
  11. 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  · 
  12. 7 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. 14 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.

  14. 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 screenshot doesn't demonstrate that Excel thinks that 1/1 and 1/20 are the same, 1/2 and 2/20 are the same, etc.

    However, what I can see from the screenshot is that your table is filtered. Do you have multiple instances of 1/1 and multiple instances of 1/20 that we cannot see? When you apply conditional formatting on duplicates, it always looks at the entire range, regardless of any filters that were applied.

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

    The advantage of CHOOSECELL over using a direct reference to a cell would be that columnletter and rownumber can be dynamic, but in what context would this be useful? Can you give an example?

    For comparison, most of my spreadsheets are based on tables, so if I want to sum specific values, I use SUMIFS to filter and then sum a column of values rather than use INDIRECT and ADDRESS to change the range that I am summing. How your data is laid out can make a huge difference in the complexity of your formulas.

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

    Roy, VLOOKUP and HLOOKUP use a default value of TRUE for their 4th argument if none is specified, meaning that the data is assumed to be sorted in ascending order, which may or may not be the case (more likely not the case). XLOOKUP and XMATCH, by default, assume that the data is can be in any order, which will always be true and so the default is always appropriate.

    XLOOKUP(A,B,C) reads as "return a reference to the cell in C that is at the same position as A in B". VLOOKUP(A,B,C,FALSE) reads as "return the value in the Cth column of B that is in the same position as A in the 1st column of B". VLOOKUP is clearly more complex.

    You are right that INDEX and MATCH/XMATCH allow mismatched ranges, and this is a disadvantage compared to XLOOKUP. VLOOKUP, when used naively, avoids mismatch issue, but then it is not robust against the columns moving around, which, in my opinion, is a bigger issue than not failing on mismatched ranges. If you do add this robustness, you also introduce the mismatch issue. So I guess you could say that VLOOKUP is better than INDEX and MATCH/XMATCH in that it lets you pick your poison. As for XLOOKUP, the fact that it fails when the ranges are mismatched is a good thing. You get the error, you fix your formula, and you're good.

    INDIRECT is a function best avoided because of its volatility. It can make life miserable if the cells using INDIRECT have many slow-calculating cells that ultimately depend on them.

    My reasoning for wanting VLOOKUP and HLOOKUP deprecated is so that they don't live longer than they need to. The longer they are used, the more people are missing out on XLOOKUP. As long as VLOOKUP and HLOOKUP are not deprecated, people may not realize that a better function exists, or they'll be stubborn and purposely stick with what they know, and they will continue using it and teaching it to young people entering the workforce, leading them in an outdated direction. The deaths of VLOOKUP and HLOOKUP will occur eventually, but way too slowly.

    Kenneth Barber shared this idea  · 
  17. 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  · 
  18. 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 Windows (Desktop Application) » Graphics  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber shared this idea  · 
  19. 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 shared this idea  · 
  20. 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  · 
← Previous 1 3 4 5 44 45

Feedback and Knowledge Base