New answers tagged formulas
You can filter out the unwanted results by using the FILTER function: =UNIQUE(FILTER(A1:A; A1:A <> "No explanation/don't know"; A1:A <> "To far"; A1:A <> "Too costly")) Check out this example spreadsheet.
This is another non-ideal work-around, but what I did was added a certain number of spaces to the end of the cell needing formatting based on the conditions I wanted, then did conditional formatting based on spaces. Ex: Column A = First Name, Column C = First Name, Column E = Some Number So what I want is if E > 50, make column A Blue, If E < 0 make ...
Top 50 recent answers are included