Results 1 to 3 of 3

Finding a streek

Threaded View

Trevasaurus Finding a streek 04-03-2013, 05:33 PM
martindwilson Re: Finding a streek 04-03-2013, 06:11 PM
Trevasaurus Re: Finding a streek 04-04-2013, 11:35 AM
  1. #1
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    Finding a streek

    Hi,

    I'm trying to find out how to return the date or time of a streak occurring in a coin toss.
    The streak I'm trying to identify is when a Heads follows a Tails (T following H) more than 4 times in a row:

    For example: t t t t h t h t h t h t h t t h h h t h t h

    Where the streak is bold.

    I have an example sheet attached with the date in column A and the coin flip in B and a 1 & 0 column in C (I was trying to use the 1's and 0's b/c I thought they'd be easier to work with than strings.

    Also, there might be some days that no coin is tossed, these days should be skipped.
    I'd like to find out when the date of a streak occurs.

    Can anyone help with this?

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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