Excel 2010 Help

Reply #7

SergeM — Mon, 24 Feb 2014 11:57:35 GMT

I am impressed by your knowledge.

Reply #6

winsumloosesum — Mon, 24 Feb 2014 01:34:09 GMT

https://app.box.com/s/5qlhjc4jcym6a1wk30ld

Enter your numbers in cell V1 (use commas)

Results appear in column W10 downward

Reply #5

RJOh — Sun, 23 Feb 2014 21:29:34 GMT

LP has charts that break down hits in a similar fashion and can be used to recheck your results.

Reply #4

SergeM — Sun, 23 Feb 2014 12:48:33 GMT

PAST DRAWN NUMBERS: |23|4|63|51|31|10|19|2|66|45|7|3|27|1|14|21|39|16|29|2| RESULT Hit 3 numbers

Reply #3

GASMETERGUY — Sun, 23 Feb 2014 12:39:51 GMT

Here is how I do it which means you should look for other ways.

I highlight the area in which I want to know how many numbers? I then click on the name manager button and give this highlighted area a throw-a-way name, such as temp1 .

I click on the cell which will contain the data I am seeking. Using the countif function, I enter this code, = countif(temp1,23) . Excel will then tell me how many times 23 came up within the area I so named.

Reply #2

cheech — Sun, 23 Feb 2014 10:28:30 GMT

Great, that did it , thank you very much I'm sure that saved me a huge amount of time.

Cheech

Reply #1

ithastobesaid — Sat, 22 Feb 2014 18:15:01 GMT

Your Hit counts were wrong. Anyhow here it is: Past Draws in Columns B2:U2, B3:U3 and B3:U4, #'s Played in Cells W2:AA2

Past Draws

23 4 63 51 31 10 19 2 66 45 7 3 27 1 14 21 39 16 29 2

23 4 63 51 31 10 19 2 66 45 7 3 27 1 14 21 39 16 29 18

22 4 63 51 31 10 19 2 66 45 7 3 27 1 14 28 39 16 29 3

#'s Played

23 2 34 21 11

Hits

4 =COUNTIF(B2:U2,W$2)+COUNTIF(B2:U2,X$2)+COUNTIF(B2:U2,Y$2)+COUNTIF(B2:U2,Z$2)+COUNTIF(B2:U2,AA$2)

3 =COUNTIF(B3:U3,W$2)+C... [ More ]

Excel 2010 Help

cheech — Sat, 22 Feb 2014 17:10:36 GMT

Need to know the correct function/formula/statement, ( I do not know the proper name of what it's

called )to enter into a Excel 2010.

That will count the amount of times of one or more matching numbers that may have been drawn with in

each past game of 20 drawn numbers.

Example: Numbers played (23,2,34,21,11)

Check with in a very large list of over 2000 past draws, each game has 20 numbers, each number in a

separate cell. The past draws are NOT sorted or have duplicated numb... [ More ]