Help with formula

[Joe]

Hello All,

I was wondering if there is a formula that would count how many times
two names in two different columns match?

For example:

Column A Column B Formula Result
John John 1

Thank you in advance for your assistance.

Regards,
Joe

 

[Joel]

=COUNTIF(A5,B5)

 

[Joe]

=COUNTIF(A5,B5)










- Show quoted text -

Wow, this works too. Thank you!