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.
|