Welcome Guest
Log In | Register )
You last visited January 16, 2017, 7:47 pm
All times shown are
Eastern Time (GMT-5:00)

Anyone with good matrix functions for MS Excel?

Topic closed. 27 replies. Last post 5 years ago by SergeM.

Page 1 of 2
PrintE-mailLink
SergeM's avatar - slow icon.png
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
Posted: June 19, 2012, 9:14 am - IP Logged

What good matrix functions are there?

    smooth11484's avatar - Lottery-053.jpg
    ohio
    United States
    Member #125198
    March 26, 2012
    1905 Posts
    Offline
    Posted: June 19, 2012, 9:20 am - IP Logged

    What good matrix functions are there?

    go rent the dvd and watch the movie

    .

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: June 19, 2012, 9:23 am - IP Logged

      I have seen all the matrix movies.

        SergeM's avatar - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        Posted: June 19, 2012, 6:36 pm - IP Logged

          United States
          Member #124493
          March 14, 2012
          7023 Posts
          Offline
          Posted: June 20, 2012, 2:18 pm - IP Logged

          i have all the best matrix functions NEO!!!

            SergeM's avatar - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 Posts
            Offline
            Posted: June 21, 2012, 3:07 am - IP Logged

            Those I showed you?


              United States
              Member #124493
              March 14, 2012
              7023 Posts
              Offline
              Posted: June 21, 2012, 3:25 am - IP Logged

              Morpheus showed me after i took the red pill...i took the red pill and fell down the rabbit hole...

              down in the hole a little rabbit said..."go to youtube...you will find the matrix function arrays there...you can learn from mr. excel...then you will be ready to take on the lotto machine city....

                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: June 21, 2012, 6:20 am - IP Logged

                I saw mistakes in several presentations, example: count unique values.

                  time*treat's avatar - radar

                  United States
                  Member #13130
                  March 30, 2005
                  2171 Posts
                  Offline
                  Posted: June 21, 2012, 1:12 pm - IP Logged

                  What good matrix functions are there?

                  'Something specific you were trying to do?

                  In neo-conned Amerika, bank robs you.
                  Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.


                    United States
                    Member #124493
                    March 14, 2012
                    7023 Posts
                    Offline
                    Posted: June 21, 2012, 4:11 pm - IP Logged

                    i would like an easier way to track the trailing skips of two 6d skip numbers...and then two 5d numbers... two 4 day numbers...two 3 day numbers...two 2 day numbers...two 1 day numbers...and two repeating numbers...

                    how often...

                    intervals...

                    most likely to lead...

                    most likely to trail...

                    longest flag formation...

                    i dont know if trinity can help me with this one...

                    so for example...when two 6 day numbers hit...what should i expect next...

                    two 3d skips?  or two 0 day skips...

                      SergeM's avatar - slow icon.png
                      Economy class
                      Belgium
                      Member #123700
                      February 27, 2012
                      4035 Posts
                      Offline
                      Posted: June 21, 2012, 7:48 pm - IP Logged

                      Concatenate


                        United States
                        Member #124493
                        March 14, 2012
                        7023 Posts
                        Offline
                        Posted: June 21, 2012, 7:57 pm - IP Logged

                        Concatenate

                        gesundheit!

                          SergeM's avatar - slow icon.png
                          Economy class
                          Belgium
                          Member #123700
                          February 27, 2012
                          4035 Posts
                          Offline
                          Posted: June 21, 2012, 9:29 pm - IP Logged

                          'Something specific you were trying to do?

                          I mainly program functions in VBA.
                          At the moment I am busy with XML.

                          The last array function that I made was unique count of values in a column.
                          I have written a better function in VBA.

                            time*treat's avatar - radar

                            United States
                            Member #13130
                            March 30, 2005
                            2171 Posts
                            Offline
                            Posted: June 23, 2012, 5:03 am - IP Logged

                            I mainly program functions in VBA.
                            At the moment I am busy with XML.

                            The last array function that I made was unique count of values in a column.
                            I have written a better function in VBA.

                            I haven't done anything with XML (I thought that was only for web browsers).

                            I only use VBA with arrays. As far as I can tell, anything that can be done on single equations can be done with arrays, too, although sometimes the "question" has to be stated differently.

                            In neo-conned Amerika, bank robs you.
                            Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

                              SergeM's avatar - slow icon.png
                              Economy class
                              Belgium
                              Member #123700
                              February 27, 2012
                              4035 Posts
                              Offline
                              Posted: June 23, 2012, 5:33 am - IP Logged

                              I haven't done anything with XML (I thought that was only for web browsers).

                              I only use VBA with arrays. As far as I can tell, anything that can be done on single equations can be done with arrays, too, although sometimes the "question" has to be stated differently.

                              I thought that it might be good to make a collection of useful array functions.

                              Usually I prefer VBA to simplify the reuse of functions. I replaced {function(function( ) ...)} by myFunction() on the sheets.
                              Most of the time I use ={sum(if( ...} constructions, there also is matching. I don't use sumproduct, but an array function instead.
                              I could find the score of some combination for a database by using array functions, but find VBA better as the input is shorter.

                              Not every worksheetfunction can be used in array functions.

                              XML is indeed for html output, maybe later for RSS. It has nothing to do with array functions or the subject here. I am just learning it.