Excel Forum

Excel Magic Trick 290: Count Codes From Column of Text Strings

See how to count codes from a column of text strings that hah multiple codes. For example: If we are counting PCP in this list: {"PCP, TP, N, N, PA";"N, N, PA";"PCP, N, PA";"TP, N, NP"} we would want to get 2.
See a formula that counts that uses the SUMPRODUCT, LEN and SUBSTITUTE functions.
LEN & SUBSTITUTE functions Counting Tricks

Got a Question? Ask it Here in the Forum.