Q:

Excel, get string value on cell

How do I get the cell from a string? I'm counting the number of times a specific string occurs on another worksheet. I have this formula:
=COUNTIF('Season 1'!$D$2:$F$1768,"*Player 1*")

Instead of having to do this manually with all other players, how do I reference the cell containing the string "Player 1" without having to manually type the string into the formula?

A:

If your list of players starts in cell A1 then try
=COUNTIF('Season 1'!$D$2:$F$1768,"*" & A1 & "*")

then copy down

