View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Help with formula

=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