counting if two columns contain the same numbers

's Computer Specifications

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

's Computer Specifications

have a look in help index for COUNTIF

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"aurion22" <(E-Mail Removed)> wrote in message
news:075DBF05-494E-4E21-B0E4-(E-Mail Removed)...
> 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

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
compare 2 columns of numbers and place the matched numbers in a 3r	Clive	Microsoft Excel Misc	5	8th Nov 2009 12:50 AM
Counting a series of text and/or numbers within columns	andrew	Microsoft Excel Misc	17	25th Jun 2008 09:49 AM
split range of numbers in two columns to as many as numbers in ran	=?Utf-8?B?YXJzb3ZhdA==?=	Microsoft Excel Misc	2	30th Oct 2006 03:57 PM
Counting Rows Then Counting Values in Columns	Michael via OfficeKB.com	Microsoft Excel Programming	1	1st Jun 2005 04:10 PM
Counting differences in numbers across columns	=?Utf-8?B?VGVkIE1ldHJv?=	Microsoft Excel Worksheet Functions	3	11th Mar 2005 09:50 PM