I have a named range, "example1", with a column (column #2 in the range) that has some text, some numerical, and some blank values.

I would like to come up with a formula to count the unique entries IF the value in a corresponding cell (in column #3 in the range) is 2.

I don't want the formula to return blank values (i.e. return the number of unique text or numerical values, but NOT blanks, in column #2, IF the value in column #3 is 2).

Any suggestions? Many thanks...