Kenneth BarberKenneth Barber

My feedback

  1. 1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Kenneth BarberKenneth Barber commented  · 

      What you're saying isn't clear. What is an "absolute"? When does Excel "automatically update" when the new year occurs?

    • 1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Kenneth BarberKenneth Barber commented  · 

        Naming the arguments SUMIFS would be greatly complicated if an arbitrarily long list of criteria were to come first and then the sum range. You would have to somehow make it clear to the user that the argument after any criteriaN is supposed to be criteria_range(N+1) if more criteria are to follow, otherwise it is sum_range.

        Also, I don't find SUMIFS any more confusing than SUMIF.
        SUMIF reads like this (roughly): if "range" meets "criteria", sum "sum_range".
        SUMIFS reads like this (roughly): sum "sum_range" where "criteria_range1" meets "criteria1" and "criteria_range2" meets "criteria2" and ...

      • 1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          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 BarberKenneth Barber commented  · 

          That's not Excel-specific.

        • 2 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Kenneth BarberKenneth Barber commented  · 

            You can avoid this issue if you use tables (go to the Insert tab and then Table). If you insert a row in the middle of a table, the formulas will automatically fill in the gap. Also, you get banded rows and easy-to-read formulas. Tables are good all around.

          • 1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              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 BarberKenneth Barber commented  · 

              This doesn't seem to take advantage of many Excel-specific features. You might as make it its own app on a mobile device, or use Visual Studio to make your own form-based program.

            • 2 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                Kenneth BarberKenneth Barber supported this idea  · 
              • 3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  Kenneth BarberKenneth Barber supported this idea  · 
                • 5 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    Kenneth BarberKenneth Barber supported this idea  · 
                  • 1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      Kenneth BarberKenneth Barber commented  · 

                      How is monospace better for editing formulas? It doesn't even help with editing programming code. It just looks "computery".

                    • 2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        Kenneth BarberKenneth Barber supported this idea  · 
                      • 3 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          Kenneth BarberKenneth Barber commented  · 

                          Duplicate of:
                          https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10770162-allow-31-characters-in-a-sheet-name

                          Also, according to the link below, the internal limit of a sheet name is 255 characters, so I think that 255 characters would be a better new limit to suggest.
                          https://exceljet.net/formula/get-sheet-name-only

                          Kenneth BarberKenneth Barber supported this idea  · 
                          Kenneth BarberKenneth Barber shared this idea  · 
                        • 6 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            Kenneth BarberKenneth Barber commented  · 

                            I can't see that being used too often. To get same effect, have a "Visible?" column, where you use SUBTOTAL functions that refer to a cell in the same row as the SUBTOTAL function. This column lets you know if the row is visible or not. Then include this column in SUMIFS.

                            Kenneth BarberKenneth Barber commented  · 

                            It would be nice if we could pass the aggregate functions themselves to as arguments, rather than strings representing them (e.g. NewFunction(SUM,A:A,B:B,E1,C:C,F1)). That is, your new function would be a higher-order function.

                            Your function is also less memory-intensive (though less versatile) than my suggestions below, where I suggest a FILTER function that can be operated on by the regular SUM, AVERAGE, etc. functions. This is because you can calculate your total, product, maximum, etc. as you are filtering, rather than doing them in separate steps.

                            https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/12934806-google-sheets-filter-function-to-solve-all-ifs-su
                            https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10886142-array-saving-filter-function-to-replace-vlookup

                          • 2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              Kenneth BarberKenneth Barber commented  · 

                              What dictates what the JSON file should look like? What are some of these tools?

                            • 31 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                Kenneth BarberKenneth Barber commented  · 

                                Why use the Paste Special window for this if you have nothing to paste? Why not just suggest for this to be done in its own separate window after right-clicking on your selected range?

                                Just use formulas. I'm not even sure why there are Paste Special options for adding and multiplying.

                              • 31 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  Kenneth BarberKenneth Barber supported this idea  · 
                                • 1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    Kenneth BarberKenneth Barber commented  · 

                                    I'm not following. What are the formulas in each cell?

                                    Kenneth BarberKenneth Barber commented  · 

                                    Interesting... Can you give a real-world example of when you'd use this?

                                    Kenneth BarberKenneth Barber commented  · 

                                    I can see this being useful for a cumulative sum, but you have to remember that the very first formula cell in the column will not follow the "cell at previous row + cell at current row" pattern, since there is no previous row for the first cell. This would have to be explicitly dealt with in the formula. Your formula would look something like:
                                    =[@[Cost]]+IF(ROW()=ROW(INDEX([Cumulative Cost],1)),
                                    0,
                                    INDEX([Cost],ROW()-ROW(INDEX([Cost],1)))

                                  • 38 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      Kenneth BarberKenneth Barber commented  · 

                                      I disagree with the "as if it is truly empty" part. Then you'll have a harder time knowing that that cell actually contains something. People making the font colour match the background is bad enough. We don't need a formula to hide itself so thoroughly.

                                    • 3 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        Kenneth BarberKenneth Barber supported this idea  · 
                                      • 1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          Kenneth BarberKenneth Barber commented  · 

                                          Resizing the window or changing the screen resolution from the Control Panel should take care of the screen size issue.

                                          As for different versions of Excel, try using trial versions of older versions. When the trial time runs out, uninstall the trial version and use CCleaner's registry cleaning function so that your computer doesn't remember you ever having the expired trial version. Reinstall the trial version and you should be good to go.

                                          Of course, if you need the newest version of Excel, you'll just have to buy it. If your company supports the Microsoft Home Use Program, then you can buy Microsoft Office for super cheap ($13).

                                        • 1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            Kenneth BarberKenneth Barber commented  · 

                                            The superscript 2 (²) in the Character Map is an actual unformatted character, but you don't have to go that far to get it. In Excel, go to the Insert tab and then Symbols. The ² character is near the top. Insert it into your sheet and copy it from there.

                                          ← Previous 1 3 4 5 25 26

                                          Feedback and Knowledge Base

                                          How it works

                                          • Create a user account if you want to add a new suggestion or vote on existing suggestions.
                                          • Select one of the feedback forums listed.
                                          • Check out the ideas others have suggested and vote on your favorites.
                                          • Be sure to search for your suggestion but if you can’t find something similar enough, you can submit your own.
                                          • Keep suggestions focused on a single idea per post and limited to 25 words or less.
                                          • When you post an idea to our forum, others will be able to subscribe to it and make comments.