counting if two columns contain the same numbers

A

aurion22

How can I get Excel to compare two columns of numbers? For example, for each
number in the first column I want to count how many in the second column
contain the same number.
Thanks
 
G

Gizmo63

=countif(B:B,A1) and fill down to match the data in column A.
(it looks in column B and counts how many cells equal cell A1)

Watch for any format mismatches that appear the same (ie a numeric '2' will
NOT match a text '2')

hth
Giz
 
Top