Help with formula

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello All,

I was wondering if there is a formula that will allow me to count how
many times a name is found in two seperate columns?

For example:

A B Formula Result
John John 1

Thank you in advance for your assistance.

Regards,
Joe
 
Assuming if "John" appears in column A three times and twice in B, you want
a result of 2:


=MIN(COUNTIF(A1:A4,"John"),COUNTIF(B1:B4,"John"))
 
Assuming if "John" appears in column A three times and twice in B, you want
a result of 2:

=MIN(COUNTIF(A1:A4,"John"),COUNTIF(B1:B4,"John"))










- Show quoted text -
Click to expand...

Thank you, this works.
 
Back
Top