Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to list all the "other" options of a Google form. As such, I am using UNIQUE to list all results from a row so:

=UNIQUE('Form Responses'!S2:S)

I would the want to exclude the following from my unique query or prevent Unique form listing the following: No explanation/don’t know, to far, Too costly.

How can I do this?

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
Thank you so much ... That worked like a charm – user2737728 Nov 29 '13 at 13:38
Glad to hear! If this worked for you, you may click "accept" on the answer. – Vidar S. Ramdal Nov 29 '13 at 14:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.