ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting the Number of Consecutive Ranges (https://www.excelbanter.com/excel-worksheet-functions/265669-counting-number-consecutive-ranges.html)

allan2005CL

Counting the Number of Consecutive Ranges
 
I need to create a formla that counts the number of times certain text will appear in a row. For example in cells A1 - J1 there could be following:
A1 = S, B1 = W,C1 = S, D1 = S, E1 = S , F1= W, G1= W, H1=S, I1 = S, J1 = S

S S W S S S W W S S

I need to know how many consecutive ranges there are of S - the answer here is (obviously) 3 - as there are 3 distinct ranges of S.

Can anyone help?


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com