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

=COUNTIF(A5,B5)

"Joe" wrote:

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

On Aug 29, 11:20 am, Joel wrote:
=COUNTIF(A5,B5)



"Joe" wrote:
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- Hide quoted text -

- Show quoted text -

Wow, this works too. Thank you!