ExcelBanter - counting non occur entries

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting non occur entries (https://www.excelbanter.com/excel-discussion-misc-queries/1954-counting-non-occur-entries.html)

excelFan

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

Frank Kabel

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

excelFan

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

All times are GMT +1. The time now is 02:53 AM.