Excel Forum

Excel Magic Trick 492: Count Matches in Single Cell

See how to use SUMPRODUCT, MID, SUBSTITUTE, and array constant in a formula to count the number of matches of 9 values entered into a single cell. See how to use SUBSTITUTE to remove spaces.

Got a Question? Ask it Here in the Forum.