Problems with UNIQUE

[RonOliver]

Hi everyone!

I got a range in B3 to C7 that contains unique values, repeated values, and blank cells. My intention is to count all individual unique cells and return "Yes" if the number of unique cells is higher than 2. However, UNIQUE only returns unique rows, but not unique cells. Using a combination of FILTER and UNIQUE to get rid of the blank cells didn't help either, as it returned a #VALUE! error. I know there are incredibly convoluted and long ways of doing this, but I'm wondering if there is a simple and easy solution. Can anybody help me with this?

Thanks!

 

[Cubist]

Without seeing your data, can't know for sure, but try something like

=IF(ROWS(UNIQUE(TOCOL(B3:C7,3)))>2, "Yes","No")

 

[RonOliver]

That's amazing. I don't know how you do this. Thanks so very much!