Column A has (say) 5 cells.
A1 = R, A2 = R, A3 = O, A4 = R, A5 = O
I need to count the Rs and Os separately
So column B ends up with B1 = 1R, B2 = 2R, B3 = 1O, B4 = 3R, B5 = 2O
or at least B1 = 1, B2 = 2, B3 = 1, B4 = 3, B5 = 2
so i can later say =B1&A1 to merge them into what i need.
thx in advance.
Bookmarks