| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
counting non occur entries
hi all,
i have two lists L1 in the range A2:A30 and L2 in the range K15:K240, like to know the number of occurrences in L1 which do not occur in L2. thanks for any help |
|
#2
|
|||
|
|||
|
Hi
COUNTA(A2:A30)-SUMPRODUCT(--(ISNUMBER(MATCH(A2:A30,K15:K240,0)))) -- Regards Frank Kabel Frankfurt, Germany "excelFan" schrieb im Newsbeitrag ... hi all, i have two lists L1 in the range A2:A30 and L2 in the range K15:K240, like to know the number of occurrences in L1 which do not occur in L2. thanks for any help |
|
#3
|
|||
|
|||
|
thanks Frank
excellent idea "Frank Kabel" wrote: Hi COUNTA(A2:A30)-SUMPRODUCT(--(ISNUMBER(MATCH(A2:A30,K15:K240,0)))) -- Regards Frank Kabel Frankfurt, Germany "excelFan" schrieb im Newsbeitrag ... hi all, i have two lists L1 in the range A2:A30 and L2 in the range K15:K240, like to know the number of occurrences in L1 which do not occur in L2. thanks for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic changes in cell entries | Excel Discussion (Misc queries) | |||
| Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Counting question | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Hybrid Mode
