+ Reply to Thread
Results 1 to 10 of 10

Identify 2 or 3 Conescutives in a string of data

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-29-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    157

    Re: Identify 2 or 3 Conescutives in a string of data

    =IF(E3=E2,"",COUNTIF(INDEX(E$1:$E1,MATCH(9.99999999E+307,$F$1:$F1)):E2,E2))

    The problem I am having is that this formula does what it was intended, I wanted to do a count to see all the consecutive occurrences of A and B. I.E. how many times did A show up 5 conesecutive times, or B 8 consecutive etc. I am able to pull 2 and 3 out of this formula, as A and B do occur 2 and 3 times in a row, but I also need to account where they occurred 2 or 3 times and it turned into a longer string. Make sense?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Identify 2 or 3 Conescutives in a string of data

    IMO, a sample file with expected results might help clarify a few things.

+ 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