CharlesCharles

My feedback

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

      CharlesCharles supported this idea  · 
    • 65 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

        CharlesCharles commented  · 

        In the same spirit a CreateList function would very very useful. It would take a range as an input, and would return an array containing a sorted list of the unique occurences of each value in the input range.

      • 445 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

          CharlesCharles commented  · 

          And have an option to search for multiple columns. So first argument (ref to match) could be a 1x2 range, and the second (match column) would be a nx2 range.

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

            CharlesCharles commented  · 

            Kenneth: I don't see how they are contradictory. The excel calculation mode is based on the first workbook opened, which results in a random behavior (basically in which calculation mode was the excel session of the person who last saved the workbook you are opening).

            And when that setting is changed, it changes for the whole excel session.

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

              CharlesCharles commented  · 

              I don't have anything against powerpivot but I am frustrated, as a user, that Microsoft focuses on the IT departments, not the users. It's like the demographics of this site, I am ready to bet 95% of the suggestions are from IT people, not end users. A pivot table that connects to the latest fashionable database technology is an IT problem, not a end user problem.

              Think of simple things like FX rates. Everyone uses that. Whether it is someone planning his holidays, or an entrepreneur preparing his business plan, or a project manager preparing a quote for a big contract, we live in a global world where we need FX rates all the time. Why isn't there a built in function to pull end of day, say ECB FX rates, directly in Excel? Big banks have UDF that connect to internal pricing servers to do that but what about outside of big banks. This is an end user problem: save your users from copy-pasting yahoo finance FX rates all the time.

              And no, if you think Excel is just a data analysis tool, you are fundamentally misunderstanding your market. It is used by anyone who need to do a quick calc, any financial modelling, any numerical analysis, whether it is scientific, engineering or business. Most finance departments in any company pretty much run on Excel, even multinationals. Yes you can do any of that in code, but keep in mind that outside of IT departments very few people can code. I'd rather be inclined to say that people who do advanced data analysis are the people who least need Excel, precisely because it is a population who can code.

              For the end user, the only noticeable useful new feature I can think of and that solves a problem I face between Excel 2007 and Excel 2016 is the addition of a waterfall chart, which are widely used by the business and required some painful hacks. This is very meagre for 10 years of development.

              CharlesCharles shared this idea  · 
            • 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

                CharlesCharles commented  · 

                That's what it should be intuitively but that's not the case. Try setting your calculations to manual and opening a new excel session.

                CharlesCharles shared this idea  · 
              • 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

                  CharlesCharles commented  · 

                  Govert: and I am a big fan and a big user of ExcelDNA. But it would still be nice to be able to write scripts and UDF in .net directly in Excel in a live session

                  CharlesCharles commented  · 

                  ...and VB.net

                  CharlesCharles supported this idea  · 
                • 8 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

                    CharlesCharles commented  · 

                    It will take you two minutes and save people a lot of time.

                    SPLIT("Text","x") should return an array {"Te","t"}
                    SPLIT("Text","ex") should return an array {"T","t"}
                    SPLIT("Text","e",1) should return "T"
                    SPLIT("Text","e",2) should return "xt"

                    JOIN(A1,B1,C1,"-") should return the content of cells A1, B1, C1, etc concatenated and separated with "-" (i.e. the last parameter of the function)
                    JOIN(A1:C1, "-") would behave as you expect

                    CharlesCharles supported this idea  · 
                  • 58 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

                      CharlesCharles commented  · 

                      If you click on the little fx at the top, even on the very latest versions of Excel, you get the same tiny, non resizable grey windows xp window with a gigantic list of functions and a search feature that doesn't search anything.

                      Can you please staff an intern to spend a day fixing it. Use case: think of when you have hundreds of UDF in addition to the hundreds of built-in function, how practical is a 50 pixels high listbox...

                      CharlesCharles 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

                        CharlesCharles shared 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

                          CharlesCharles commented  · 

                          We should move away from a single grid per tab and adopt Apple's Number approach of a canvas on which we have shapes, some of which may be charts, some of which may be a grid, some of which may be text.

                          Use case: if you have used excel more than 5min in your life, I am sure you found yourself with two tables, one above the other, and being frustrated trying to align the column width when the content of the two tables do not dictate the same column widths.

                          I am sure it is possible to do it in a backward compatible way with a default grid when the grid is not specified.

                          CharlesCharles supported this idea  · 

                        Feedback and Knowledge Base