You last visited June 19, 2013, 7:47 am All times shown are
Eastern Time (GMT-5:00) | Anyone with good matrix functions for MS Excel?Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 19, 2012, 9:14 am - IP Logged | |
What good matrix functions are there? | | |
ohio United States Member #125207 March 26, 2012 1422 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 | | |
Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 19, 2012, 9:23 am - IP Logged | |
I have seen all the matrix movies. | | |
Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 19, 2012, 6:36 pm - IP Logged | |
| | |
KEEP YOUR EYE ON THE BALL! NYC United States Member #124503 March 14, 2012 5164 Posts Offline | | Posted: June 20, 2012, 2:18 pm - IP Logged | |
i have all the best matrix functions NEO!!! est modus in rebus --- Catch the Lightning! He deals the cards to find the answer, the S. G. of chance, the hidden law of a probable outcome, the numbers lead a dance. - Sting. | | |
Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 21, 2012, 3:07 am - IP Logged | |
| | |
KEEP YOUR EYE ON THE BALL! NYC United States Member #124503 March 14, 2012 5164 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.... est modus in rebus --- Catch the Lightning! He deals the cards to find the answer, the S. G. of chance, the hidden law of a probable outcome, the numbers lead a dance. - Sting. | | |
Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 21, 2012, 6:20 am - IP Logged | |
I saw mistakes in several presentations, example: count unique values. | | |
United States Member #13375 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. | | |
KEEP YOUR EYE ON THE BALL! NYC United States Member #124503 March 14, 2012 5164 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... est modus in rebus --- Catch the Lightning! He deals the cards to find the answer, the S. G. of chance, the hidden law of a probable outcome, the numbers lead a dance. - Sting. | | |
Aruba Member #123712 February 27, 2012 1799 Posts Offline | | Posted: June 21, 2012, 7:48 pm - IP Logged | |
| | |
KEEP YOUR EYE ON THE BALL! NYC United States Member #124503 March 14, 2012 5164 Posts Offline | | Posted: June 21, 2012, 7:57 pm - IP Logged | |
gesundheit! est modus in rebus --- Catch the Lightning! He deals the cards to find the answer, the S. G. of chance, the hidden law of a probable outcome, the numbers lead a dance. - Sting. | | |
Aruba Member #123712 February 27, 2012 1799 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. | | |
United States Member #13375 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. | | |
Aruba Member #123712 February 27, 2012 1799 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. | | |
|