# Counting Multiple Sequences Within One Formula

1. ## Re: Counting Multiple Sequences Within One Formula

Originally Posted by loucifer777
dear XOR LX ,thank u so much,where i copy/paste the formula?
Anywhere you want.

On second thoughts, if there are not necessarily entries all the way to row 100 then use:

=SUM(N(MMULT(TRANSPOSE(ROW(C6:C100)^0),N(N(OFFSET(C6,ROW(C6:C100)-MIN(ROW(C6:C100)),{0,4,7,10}))=N(OFFSET(C6,MOD(ROW(C6:C100)-MIN(ROW(C6:C100)),5),{0,4,7,10}))))=COUNT(C6:C100)))

Returns 4 for the workbook provided.

Remember to commit with CTRL+SHIFT+ENTER!

Regards

2. ## Re: Counting Multiple Sequences Within One Formula

dear bo,i dont want to count,just when the sequence apears9any of the sequences),i want the formula to write 12 or ''yes''

3. ## Re: Counting Multiple Sequences Within One Formula

dear xor lx,thank you for your time which you spend to me ,really thank you.i trey to copy paste but i get an error message can you help me?

4. ## Re: Counting Multiple Sequences Within One Formula

Originally Posted by loucifer777
dear bo,i dont want to count,just when the sequence apears9any of the sequences),i want the formula to write 12 or ''yes''
Ok, I'm lost now. I supplied a formula based on your earlier statement:

Originally Posted by loucifer777
we need one formula to count all sequences with that order
Best of luck.

5. ## Re: Counting Multiple Sequences Within One Formula

dear all ,i just mean that : we have a column which i put manually randomly the numbers 1 and 2,yes? the needed formula should track the column and when the sequence happened should write ''yes'' or ''good".now what is the sequence? example 1: 12 111 12 111 12 ,example 2: 22 221 22 221 22, example 3: 12 112 12 112 12, example 4: 21 112 21 112 21, example 5: 11 222 11 222 11.....so if you see this outcome in a the column c:c for example what we see? we see that the last 2 numbers with the 6,7,11,12 are equal in value and in order.the same with the numbers between.

formula should say :if in c:c the last 2 numbers are equal with the last sixth and seventh and equal with eleventh and twelveth and the same time the last 3,4,5 numbers are equal and same order with 8,9,10 say yes ,if no say zero

so we track column and when this happend say"yes"otherwise zero.thanks again!!

7. ## Re: Counting Multiple Sequences Within One Formula

@loucifer777

https://www.excelforum.com/excel-gen...-sequence.html

B1 =IF(COUNTIF(\$A\$1:\$A\$10,\$A1)=COUNTIF(\$A\$1:\$A1,\$A1),"WOW","") and drag below.

8. ## Re: Counting Multiple Sequences Within One Formula

not exactly,cause the results at A:A might g0 to 300 or 1000, i ask something which should not be so difficult to understand.please give one formula correct please in this forum

9. ## Re: Counting Multiple Sequences Within One Formula

i said the lat with fifth and seventh,yes??
and at my previous post nobody gave a correct formula for something not so hard for the experts here..so is better before any your ansewer to tell us how much money you want and dont take our time

10. ## Re: Counting Multiple Sequences Within One Formula

not exactly,cause the results at A:A might g0 to 300 or 1000, i ask something which should not be so difficult to understand.please give one formula correct please in this forum
Then amend the range

B1 =IF(COUNTIF(\$A\$1:\$A\$10000,\$A1)=COUNTIF(\$A\$1:\$A1,\$A1),"WOW","") and drag below.

11. ## Re: Counting Multiple Sequences Within One Formula

Originally Posted by loucifer777
not exactly,cause the results at A:A might g0 to 300 or 1000, i ask something which should not be so difficult to understand.please give one formula correct please in this forum
Originally Posted by loucifer777
i said the lat with fifth and seventh,yes??
and at my previous post nobody gave a correct formula for something not so hard for the experts here..so is better before any your ansewer to tell us how much money you want and dont take our time
With that ungrateful attitude, you can take your queries elsewhere.

Page 2 of 2 First 1 2

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1