Results 1 to 7 of 7

Recognizing a pattern of 0's

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2016
    Location
    ND, USA
    MS-Off Ver
    Standard 2010
    Posts
    2

    Recognizing a pattern of 0's

    I am working on a simulation problem for a class. I am simulating a simple game where you flip a coin 10 times, Heads = 0, Tails = 1. To win the game, I need to flip 4 heads (0's) in a row. How can I get Excel to recognize four 0's in a row? I can generate the random numbers (=RANDBETWEEN(0,1)) but I can't figure out the right formula to generate a True (win) or False (lose) output. An example would be:
    0 1 0 1 0 1 0 1 0 1 = Loss
    1 1 0 1 0 1 0 0 0 0 = Win

    I think I could do it using IF/AND functions but I think it would get pretty complicated doing it that way.
    Last edited by gryanb; 10-14-2016 at 12:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Continuing a pattern on autofil without pattern re-starting
    By jakeyoung111 in forum Excel General
    Replies: 4
    Last Post: 06-22-2016, 11:11 AM
  2. Excel autofill not recognizing increment pattern.
    By s.hill in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2015, 12:42 PM
  3. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  4. [SOLVED] Autofill Issues- recognizing pattern
    By ryanaskren in forum Excel General
    Replies: 3
    Last Post: 08-28-2014, 09:45 AM
  5. [SOLVED] Autofill not recognizing pattern
    By WILLPOU in forum Excel General
    Replies: 4
    Last Post: 11-05-2013, 11:24 PM
  6. pattern recognizing in excel for a large data set
    By maulik1k in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 10-09-2013, 10:27 PM
  7. Replies: 4
    Last Post: 06-09-2010, 11:54 PM

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