Forum Discussion
AneliaM
Jan 29, 2020Copper Contributor
Excel formula to count number of alternations from any value to a specific value
Hello guys, I need a formula that counts the number of times a specific value starts appearing in a row. In the below pic I need a formula that will count how many times SL started to appear, th...
Riny_van_Eekelen
Jan 29, 2020Platinum Contributor
Perhaps like in the attached example? See the formula in H. Adjust the ranges to your particular situation
AneliaM
Feb 03, 2020Copper Contributor
Riny_van_Eekelen Actually that worked just perfectly. Thanks so much for the help!