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.