LinkBack URL
About LinkBacks
Anybody please.....
How to count a list of data that not match to a range as criteria and count duplicate as one and ignoring blanks....
Attachment 563929
as the example, i want the result (F1) will be 14.
Thank you for helps.....
Anybody please.....
How to count a list of data that not match to a range as criteria and count duplicate as one and ignoring blanks....
Attachment 563929
as the example, i want the result (F1) will be 14.
Thank you for helps.....
Last edited by brake; 03-03-2018 at 06:07 AM.
Try this ...
=SUM(IF(COUNTIF(C3:C6,A2:A27)=0,1/COUNTIF(A2:A27,A2:A27&"")))-(COUNTBLANK(A2:A27)>0)
Array formula, enter with Ctrl+Shift+Enter.
Re: Count list not Match to a range as criteria and count duplicate as one and ignoring bl
It works well, Thank's a million for your help...... GoodLuck!!!!Originally Posted by Phuocam
{=SUM(IF(COUNTIF(C2:C5;A2:A27)=0;1/COUNTIF(A2:A27;A2:A27&"")))-(COUNTBLANK(A2:A27)>0)}
(Ctrl+Shift+Enter)
Last edited by brake; 03-03-2018 at 05:07 AM. Reason: adding the worked formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks