Closed Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 26 of 26

Counting Multiple Sequences Within One Formula

  1. #16
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,196

    Re: Counting Multiple Sequences Within One Formula

    Quote Originally Posted by loucifer777 View Post
    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
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  2. #17
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    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. #18
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    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?
    Attached Files Attached Files

  4. #19
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,196

    Re: Counting Multiple Sequences Within One Formula

    Quote Originally Posted by loucifer777 View Post
    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:

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

  5. #20
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    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!!
    Last edited by loucifer777; 05-24-2020 at 01:06 AM.

  6. #21
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    Re: Counting Multiple Sequences Within One Formula

    i really apriciate your try

  7. #22
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,855

    Re: Counting Multiple Sequences Within One Formula

    @loucifer777

    for your question below:
    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.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  8. #23
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    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. #24
    Banned User!
    Join Date
    03-29-2020
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    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. #25
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,855

    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. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    37,691

    Re: Counting Multiple Sequences Within One Formula

    Quote Originally Posted by loucifer777 View Post
    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
    Quote Originally Posted by loucifer777 View Post
    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.
    Last edited by AliGW; 05-24-2020 at 09:06 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

Bookmarks

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