HI, Please somebody give me a formula on how to count the number of groups of sequence number in exc-CodePudding

Home > database > HI, Please somebody give me a formula on how to count the number of groups of sequence number in exc

HI, Please somebody give me a formula on how to count the number of groups of sequence number in exc

Time：12-27

I have 001001110110

I need a forumla which will count the number of groups of 1 The above forumla should give me an answer '3' as there are three groups of 1.

CodePudding user response：

Please review