+ Reply to Thread
Results 1 to 1 of 1

Check the number of occurences of a word in a list

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    48

    Check the number of occurences of a word in a list

    Hello,

    I have attached a EXAMPLE 1 file.

    In this file, each line has :

    - a serie of 10 various numbers
    - 10 x the word "GREEN"
    - 1 x the word "YELLOW"

    I would like to know how many consecutive GREEN are in each line, and if the YELLOW is consecutive to a GREEN.

    For example :

    in line 1, I have 1 serie of 3 consecutive GREEN, 2 series of 2 consecutive GREEN, 1 YELLOW is consecutive to a GREEN.
    in line 2, I have 1 serie of 4 consecutive GREEN.

    Thanks for your help.
    Askalian
    Attached Files Attached Files

+ Reply to Thread

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