View original (French)

Sheets NBVAL UNIQUE FILTER shows 1

Solved
fab31_ -  

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

  1. ALS35

    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