Forum Discussion
Solved
How to use count unique by using filter under multiple criteria from different colume
Hi all expertises, Last time, I learnt the following formula to count the unique by using filter under single criteria. Formula is =count(unique(filter(A:A, B:B="correct"). The formula is correct ...
You can multiply the conditions:
=COUNTA(UNIQUE(FILTER(A:A, (B:B="correct")*(C:C=37)*(D:D>25))
You can multiply the conditions:
=COUNTA(UNIQUE(FILTER(A:A, (B:B="correct")*(C:C=37)*(D:D>25))
- HI Hans, thank you so so much. I got the correct answer. Use * ( ) to add additional criteria. Thanks for your great help
