+ Reply to Thread
Results 1 to 5 of 5

How to count how many time that '3' consecutive number occurs

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Asia
    MS-Off Ver
    2013
    Posts
    7

    How to count how many time that '3' consecutive number occurs

    Hi,

    http://i.imgur.com/RhuXXpc.jpg

    PLEASE see the Picture in the Link above
    (Sorry I cannot insert picture here, it said file size is too large.


    Hope someone can help me out very soon,

    Thank you so very much

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How to count how many time that '3' consecutive number occurs

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    Asia
    MS-Off Ver
    2013
    Posts
    7

    Re: How to count how many time that '3' consecutive number occurs

    Hi,

    Sorry for that,

    I have uploaded and you can have a look the Example Excel file here

    ***REMOVED*** (Please see attached files on Post #5 instead, thank you)

    If there is any doubt on my question, please don't hesitate to ask me.


    Hope someone can help me out very soon,

    Thank you so much
    Last edited by memooo99; 11-06-2014 at 02:44 AM. Reason: Replace uploaded file with attached file on post #5

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How to count how many time that '3' consecutive number occurs

    Please upload your workbook to the forum, not all members are able (or willing) to download from file hosting sites

    (sorry to be a pain )

  5. #5
    Registered User
    Join Date
    10-22-2014
    Location
    Asia
    MS-Off Ver
    2013
    Posts
    7

    Re: How to count how many time that '3' consecutive number occurs

    Oops, No problem my friend,

    Thanks for telling me that,

    It's not a pain lol



    I'm still waiting for the solution btw, >_<

    Thank you so much!!
    Attached Files Attached Files
    Last edited by memooo99; 11-06-2014 at 02:42 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count the number of consecutive times a value occurs
    By mbhc77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 07:58 AM
  2. Count Consecutive 0s until >0 number occurs in the row
    By NWA123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-29-2012, 03:28 PM
  3. [SOLVED] Re: How to count the number of times something occurs within a certain month
    By Joyce in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2005, 04:05 PM
  4. [SOLVED] How to count the number of times something occurs within a certain month
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 02:05 PM
  5. Replies: 3
    Last Post: 02-03-2005, 06:06 AM

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