Hello!
What formula may help to get the number of b=5 with:
A1 b1
A2 bubble
A3 ball
Thank you!
Hello!
What formula may help to get the number of b=5 with:
A1 b1
A2 bubble
A3 ball
Thank you!
Try =SUMPRODUCT(LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"b","")))