Hi,

I am working on a spreadsheet that has some strings in columns A2:K2.
In a separate sheet I have in rows A2:A15 some strings (PP1, PP2, PP3...PP15)
In cell L2 I want to be able to put a formula to count how many time any of the strings in A2:A15 appear in A2:K2.

Thank you any help in greatly appreciated.