Count the number of unique numbers/strings in a column, but limit the set to the rows that satisfy a certain condition in another column

Asked Dec 15 '21 at 16:29

Active Dec 15 '21 at 16:29

Viewed 25 times

This: "'=COUNTA(UNIQUE(D2:D724))"' works, but now I want to limit the input to this formula as follows:

only for the rows for which in another column a logical condition is satisfied, count the number of unique numbers/strings in column D for this limited set

So I want to limit the set D2:D724 in =COUNTA(UNIQUE(D2:D724))

I don't want to use filters for this, I want to do this with formulas.

asked Dec 15 '21 at 16:29

babipsylon

2

Check out the FILTER() function (ie not manual filtering using the UI). – DS_London Dec 15 '21 at 16:41
Thx, this seemed to work: =COUNTA(UNIQUE(FILTER(E2:E724;V2:V724>-1;"error"))) – babipsylon Dec 15 '21 at 18:35

Count the number of unique numbers/strings in a column, but limit the set to the rows that satisfy a certain condition in another column

0 Answers0