| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting data in columns | Excel Discussion (Misc queries) | |||
| How do I input numbers used to select cells in several columns | Excel Discussion (Misc queries) | |||
| EXCEL should let me establish unlimited numbers of columns. | Excel Discussion (Misc queries) | |||
| Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
| how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
Linear Mode
