Need an excel formula

Reply #16

omiller315 — Wed, 22 Jan 2014 21:56:32 GMT

I think VBA is the way to go. You can accomplish so much with very little coding. Of course it isn't for everyone and you do have to learn it. Knowing VB6, meant VBA was a piece of cake. If you need code, I can gladly write it for you, but it will be a macro and I know some people dont' trust them, since they could be malicious. I would never copy/paste VBA off the internet without knowing what it did 1st. I work IT and someone I work with use to do it all the time. Had to train them to come to... [ More ]

Reply #15

LottoBoner — Thu, 16 Jan 2014 06:56:01 GMT

there was an ad when I visted this thread. Lynda.com

It has a search function.

Mr. excel is good.

There is only two veteran guys on YT that do excel well from what I know.

Of course there are fringe teachers.

Thats where I learned arrays. They are pretty and cool, but they aint helping me win too much.

Bill Jelen and some other dude are on YT.

And some student of mr excel is teaching VBA on YT too.

I was watching the video but I got bored.

Reply #14

GASMETERGUY — Thu, 16 Jan 2014 05:25:27 GMT

That is a good site. I go there often. They need a search function, tho.

Reply #13

winsumloosesum — Wed, 15 Jan 2014 22:32:42 GMT

Not sure if this is what you wanted:

https://app.box.com/s/ehyteozp4h2u9f1ufcc8

Reply #12

SergeM — Mon, 13 Jan 2014 02:40:47 GMT

I use: =Score(A1:A4;B1:B4)

One function, two parameters, for lotto type, same as keno.

Reply #11

MillionsWanted — Mon, 13 Jan 2014 02:28:34 GMT

I use it for Keno, not Pick 3/4.

Reply #10

SergeM — Mon, 13 Jan 2014 02:11:14 GMT

Table A B C

E 1 2 3

F 4 5 6

G 7 8 9

Column h.

E

Row h.

A

Found 1

I use three parameters, but according to school you use like seven parameters. Microsoft is sleeping, nobody is moaning.

Reply #9

SergeM — Mon, 13 Jan 2014 02:06:59 GMT

You posted the wrong function. You needed =SUMPRODUCT(COUNTIF($A$2:$A$10,$B2:$B10)). Use comma or semicolon according to your OS.

Sumproduct works, but there is no product, just a sum. Both functions aren't usable for pick 3/4.

You are supposed to pick the easy one.

I stopped using nested functions for custom functions.

Reply #8

MillionsWanted — Mon, 13 Jan 2014 01:56:39 GMT

You're probably the expert, but I'm not that picky as long as I get the correct results.

I found it here: http://www.mrexcel.com/forum/excel-questions/626774-count-duplicate-values-between-two-columns.html

The page got a few other suggestions as well.

Reply #7

SergeM — Mon, 13 Jan 2014 01:50:23 GMT

4 2 4

2 2 4

2 Score boxed

1 2 3

1 3 2

1 Score straight

2 3 4

1 5 4

1 Score lotto

Reply #6

SergeM — Mon, 13 Jan 2014 01:40:25 GMT

On which dumb fooling site have you found that stuff?

The idea of using sumproduct() is good, but the rest is bad.

Reply #5

MillionsWanted — Sun, 12 Jan 2014 20:23:41 GMT

Thank you to anyone who have tried to help including those who sent me messages.

I found this solution on a website:

=SUMPRODUCT(ISNUMBER(MATCH($D$16:$W$16;$D$17:$W$17;0))+0)

It's supposed to check for occurences of same numbers between the drawn numbers and the predicted numbers.

Reply #4

SergeM — Sun, 12 Jan 2014 13:07:00 GMT

? =Score('row 1';'row 2

Reply #3

MillionsWanted — Sun, 12 Jan 2014 11:22:57 GMT

Thanks, but not quite what I am looking for.

Let me add: The number 3 result in my example is because it was three numbers which appeared in both rows/columns, 1, 3 and 5.

Reply #2

Killians69 — Sun, 12 Jan 2014 04:05:05 GMT

You may use the countif formula.

=COUNTIF(a1:g1,3)+COUNTIF(a5:g5,3

Reply #1

SergeM — Sun, 12 Jan 2014 01:02:30 GMT

You need to write a matrix function for this.

Need an excel formula

MillionsWanted — Sat, 11 Jan 2014 13:36:56 GMT

I need to count how many times i find the same numbers in two rows:

Row 1:

1

2

3

4

5

Row 2:

1

3

5

8

9

=(Formula) = 3

Thankful for any help.