hello everybody I am new to excel and I am trying to figure out how to count continuous letters in different cells in a row. the version of excel I have is 2003.
the case will be like this:
each row goes from b1 to cm1.each cell in that row contains 1 letter a, b or c.
the letter b will have no influence in the result, it will not count.
the letters that I would like to count are a and c. the results of a will be displayed in cell cn and the results of c in co.
the result I am looking for is how many counts of 4 plus consecutive a and c are.
aabbbaaa cccbcc aaaacaca bbbbcbcccca in this case a= 2 four+ counts c=2 four+ cunts b don't matters.
I have 50 rows in the document.
thanks to all in advance. your help will be really appreciated.