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) |