| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the numbers?
Does anyone have any suggestion on how to count the matched values?
There is a list of values under column A & B [Column A] 1,5,6,8,9,10,3,20 [Column B] 6,4,9 I would like to count the number of values in column B, which is matched any value in column A. In this case, the matched values are 6 & 9, and it will return 2 in cell C1. Does anyone have any suggestions? Thank you for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Sum Count of Two Numbers in the same Row | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Threaded Mode
