I'm sure it's something simple, but it's just not coming to me. I'm assuming I need to combine a vlookup and countif so that i can get a result of how many A's L's or P's that each person has from the range in O1:P12 and place it next to their name in column N
any help would be appreciated, and if it will require VB, I'd rather even use a couple of formulas, that have to reference each other.
<tbody>
</tbody>
any help would be appreciated, and if it will require VB, I'd rather even use a couple of formulas, that have to reference each other.
John | John | A | |
Mark | John | L | |
Yvette | John | P | |
John | P | ||
Mark | A | ||
Mark | A | ||
Mark | L | ||
Mark | P | ||
Yvette | L | ||
Yvette | P | ||
Yvette | P | ||
Yvette | P |
<tbody>
</tbody>