Thread: [Solved] Count number of Ms between Hs in a column
View Single Post
 
Old 05-11-2020, 05:49 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
I'm sorry my computer can't connect to a wi-fi.
The range starts in A2 with a value of H. A3 to A5 contain M (3 Ms), A6 is H, A7 is M, A8 is M and A9' again H.
The formula in B2 should return 3 because A3 to A5 contain 3 M.
B6 should be 2 because B7 and BH has 2 M.
Reply With Quote