Google Spreadsheet Post #2309
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Dec-04-2017
question by: Samjco
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/miB-3bOsHsQ;context-place=forum/docs
How to add conditions to a filter
I have this example sheet:
https://docs.google.com/
It allows me to pull in data into a dropdown on sheet1 based on data in sheet2 where there is an "X" in the availability.
The filter that does this on sheet2 is:
=FILTER(A2:A,B2:B="x")
However, I am trying to extend the filter a bit by not showing the name in the list where B2:B = "X", if I have selected it on sheet1
No comments:
Post a Comment