Anyone with good matrix functions for MS Excel?

Reply #27

SergeM — Mon, 25 Jun 2012 19:31:13 GMT

It's nice to hear that.

Reply #26

Todd — Mon, 25 Jun 2012 19:13:45 GMT

You can put all the free wheels you want out there. The only thing you can't do is to copy something from Lottery Post and publish it yourself. That's copyright infringement. But something that doesn't exist on Lottery Post? What would I care if you did that

Reply #25

SergeM — Mon, 25 Jun 2012 14:34:13 GMT

Years ago I thought of putting wheels online in Excel for free use. You understand that people people like Todd, Gail Howard and others wouldn't be too happy with that. There would be posting threads only.

For a collection of array (=matrix) functions, I use a Dutch version of Windows and Excel, and the American syntax is like upside down. Semicolon, point, comma, ... all mixed up. The names of the functions differ too. With recorded macro's you may have a complete program in Excel, no big pr... [ More ]

Reply #24

time*treat — Mon, 25 Jun 2012 13:31:40 GMT

Old threads get locked and new people ask old questions. Different questions/topics and answers, at different times, by different people would natually make for scattered responses. Mistakes do come up, but you have the option of linking to a specific (corrected) post, rather than just to the thread in question.

For the collection of macro links, I used notepad, since I wasn't doing anything too complex as a first try. I kept it simple by not using embedded hyperlinks.

https://www.lotteryp... [ More ]

Reply #23

SergeM — Mon, 25 Jun 2012 12:50:42 GMT

Post them here

Reply #22

SergeM — Mon, 25 Jun 2012 11:40:41 GMT

They should have put it all in one Excel thread instead of spreading it all over the place.

I found mistakes in many threads. Some topics come up several times. There could be a recovering thread linking to unique correct threads (direct adres to the post).

For a collection of links, all you need is a word.docx or text.txt or maybe an excel.xlsx?

Searching probably works easily by Google, example: Lotterypost Excel Array 2010 + ENTER.

Reply #21

time*treat — Mon, 25 Jun 2012 11:05:41 GMT

With patient use of the search function, you'd (probably) find many array functions scattered in old threads.

Then it's just a matter of consolidating them either as a pointing (collection of links) document or a re-written collection of functions.

I did it once as a pointing document for most of the VBA code posted on LP (up to that date). It took me about a day, but the result is that if I'm looking for something that I remember was in the form of a macro, I can start with that page rath... [ More ]

Reply #20

SergeM — Mon, 25 Jun 2012 10:21:35 GMT

upside down pascal case

Reply #19

LottoBoner — Sun, 24 Jun 2012 19:22:16 GMT

GeSuNdHeIt

Reply #18

SergeM — Sun, 24 Jun 2012 19:10:47 GMT

camelcase

Reply #17

LottoBoner — Sun, 24 Jun 2012 18:02:11 GMT

GESUNDHEIT

Reply #16

SergeM — Sun, 24 Jun 2012 13:03:10 GMT

I just drew the conclusion that you don't share.

Reply #15

SergeM — Sat, 23 Jun 2012 20:14:26 GMT

Uppercase

Reply #14

SergeM — Sat, 23 Jun 2012 09:33:59 GMT

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 worksheetf... [ More ]

Reply #13

time*treat — Sat, 23 Jun 2012 09:03:48 GMT

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.

Reply #12

SergeM — Fri, 22 Jun 2012 01:29:54 GMT

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.

Reply #11

LottoBoner — Thu, 21 Jun 2012 23:57:15 GMT

gesundheit

Reply #10

SergeM — Thu, 21 Jun 2012 23:48:00 GMT

Concatenate

Reply #9

LottoBoner — Thu, 21 Jun 2012 20:11:50 GMT

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..... [ More ]

Reply #8

time*treat — Thu, 21 Jun 2012 17:12:12 GMT

'Something specific you were trying to do

Reply #7

SergeM — Thu, 21 Jun 2012 10:20:32 GMT

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

Reply #6

LottoBoner — Thu, 21 Jun 2012 07:25:02 GMT

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

Reply #5

SergeM — Thu, 21 Jun 2012 07:07:37 GMT

Those I showed you

Reply #4

LottoBoner — Wed, 20 Jun 2012 18:18:18 GMT

i have all the best matrix functions NEO

Reply #3

SergeM — Tue, 19 Jun 2012 22:36:52 GMT

http://office.microsoft.com/en-us/excel-help/more-arrays-introducing-array-constants-in-excel-HA001087291.aspx?CTT=5 origin=HA001087227

Reply #2

SergeM — Tue, 19 Jun 2012 13:23:56 GMT

I have seen all the matrix movies.

Reply #1

smooth11484 — Tue, 19 Jun 2012 13:20:35 GMT

go rent the dvd and watch the movie

Anyone with good matrix functions for MS Excel?

SergeM — Tue, 19 Jun 2012 13:14:48 GMT

What good matrix functions are there