I am working on a spreadsheet that has one cell containing the up to 6 variables ( P,O,S,AN, EN, PN). the cell might contain just one variable (P) or it can be a combination of the other variables. Using a different cell, I need to count the occurrence of each variable.
For example : on cell A1: P,O,S on cell A2: P, O
On the cell BI: I need to get the occurrence of the value "P" from cells A1 and A2. On cell B2: I need to get the occurrence of the value "O" from A1 and A2. Is there a way to do this? Thank you for your help.
Bookmarks