counting if two columns contain the same numbers
 

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

counting if two columns contain the same numbers
 

have a look in help index for COUNTIF

--
Don Guillett
SalesAid Software

"aurion22" wrote in message
...
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

counting if two columns contain the same numbers
 

=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

"aurion22" wrote:

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