can someone help me with formula for excel?

Reply #13

jester001 — Sat, 11 Jul 2009 05:27:59 GMT

finally got it to work. :) tnx alot kind sirs for all the help.

Reply #12

jester001 — Sat, 11 Jul 2009 04:04:51 GMT

hello again sir i just did what you told me what i get are all zero's.

Reply #11

jester001 — Sat, 11 Jul 2009 03:26:08 GMT

ok tnx alot sir will try it out. :) tnx again sir.

Reply #10

phileight — Sat, 11 Jul 2009 01:40:13 GMT

Did you remember to start with ctrl shift enter to let excel know that it was an array formula?

Macro on tool bar goto tools macro record new macro use default name or enter one, select cell you want result displayed in, enter your formula. stop macro you now have a macro you can use by pressing alt f8 and selecting

good luck

Reply #9

jester001 — Fri, 10 Jul 2009 16:15:26 GMT

=SUMPRODUCT(--($B$2:$B$2556=$AB2),(--($B$3:$B$2557=$AC1)))

hello carbob? is the formula right? im getting only zero's tnx again. btw do you know how to convert it to macro? tnx again sir.

Reply #8

jester001 — Fri, 10 Jul 2009 13:36:22 GMT

to knucklehead the one that you gave me worked. :) tnx alot.

carbob was teaching me the answer to my sexond question.

to carbob: ok tnx alot sir. will do just that.

tnx again to both of you for the help.

Reply #7

KnuckleHead — Fri, 10 Jul 2009 12:37:50 GMT

Sorry, I misunderstood the question...

Reply #6

CARBOB — Fri, 10 Jul 2009 09:49:05 GMT

It would take a macro to do that. The example I posted is for one column only. You created 2 more tables like the example, change the ranges, then you have all 3 positions. When you add a draw, do a a replace to current row.

Reply #5

jester001 — Fri, 10 Jul 2009 04:54:37 GMT

hello again sir carbob i just have a question again can it also be done automatically for example we just put a number on a certain row and then it automatically updates the numbes? lso can this be done individually like in pick 3 we have p1 p2 p3 i wanted to analyze each one of them and their following numbers tnx again sir.

Reply #4

jester001 — Fri, 10 Jul 2009 04:22:22 GMT

tnx alot carbob. :) can this be done individually for example only the numbers in the a coulmn are sorted then seperate for the b coulmn and c column? so there will be three of them tnx agan sir.

Reply #3

CARBOB — Thu, 09 Jul 2009 22:58:36 GMT

If I understand what they are looking for a formula to count the number of times a digit has followed another digit. If so, this formula will work =SUMPRODUCT(--($U$7:$U$17=$X7),(--($U$8:$U$18=Y$6)))

Make sure to use Ctrl-Shift-Enter to enter the formula.

Reply #2

jester001 — Thu, 09 Jul 2009 22:36:26 GMT

ok sir tnx alot. will try it out. :) tnx again sir.

Reply #1

KnuckleHead — Thu, 09 Jul 2009 19:38:09 GMT

I believe what you need is something like:

=COUNTIF(A1...A30, =0 ) change the 0 to what ever number you want to count

That formula should be placed in each cell that you want the counted numbers to be in.

0=how many 0's

1=how many 1's

2=how many 2's

etc. thru 9

You can change the range (A1...A30) that you want to count.

Hope that's what you were looking for...

can someone help me with formula for excel?

jester001 — Thu, 09 Jul 2009 18:02:35 GMT

hello sir/mam

can someone please help me for some excel formula. for example i have rows A1toA30 and i wanted to calculate the number of times that each number has appeared in the cell that i have selected. the numbers are from 0 to 9 and i just wanted to know how many times each number has appeared in the cells that i have mentioned.

also is it possible to calculate in excel the number of times a certain number is followed by a certain number for example in cell A1toA30 there are numbers... [ More ]