View original (French)

Sheets NBVAL UNIQUE FILTER shows 1

Solved
fab31_ Posted messages 24 Registration date   Status Member Last intervention   -  
fab31_ Posted messages 24 Registration date   Status Member Last intervention   -

Hello,

I use the following formula to count the number of unique values based on criteria

=COUNT(UNIQUE(FILTER('Order Tracking'!A:A; 'Order Tracking'!K:K <> "Ent1"; 'Order Tracking'!K:K <> "Ent2"; 'Order Tracking'!Q:Q = "Closed"; 'Order Tracking'!R:R >= B2; 'Order Tracking'!R:R <= C2; 'Order Tracking'!N:N = "Yes")))

The formula works correctly but when no value is found, the formula returns 1 instead of 0.

Do you know how to make 0 come back if no match is found?

Thanks for your help.

2 answers

Answer 1 / 2
ALS35 Posted messages 1034 Registration date   Status Member Last intervention   147
 

Hello,

You can try this:

 =IFERROR(ROWS(UNIQUE(FILTER('Order Tracking'!A:A; 'Order Tracking'!K:K <> "Ent1"; 'Order Tracking'!K:K <> "Ent2"; 'Order Tracking'!Q:Q = "Clôturée"; 'Order Tracking'!R:R >= B2; 'Order Tracking'!R:R <= C2; 'Order Tracking'!N:N ="Oui")));"")

Best regards
1
Answer 2 / 2
fab31_ Posted messages 24 Registration date   Status Member Last intervention  
 

Hello,

Looks good.

Thank you very much.
0