Forum Discussion
Use Multiple columns as filter
I've been lurking in the forums, finding all kinds of neat things to do with a scheduling spreadsheet we use, so thank you all for questions and responses you've posted! I have a question that I can...
erikmitchell Great question. Sorry to hear that you can't use Power Query, as this would have made it trivial!
I would set up an input cell that you can put the user selection in O1 or something, and set up column N to do a COUNTIF(J2:M2,$O$1), and filter on the '1's that should appear whenever the user is selected. You could also remove the manual filtering step, by having a second column that counts the cumulative number of times that the '1' appears, and then use an INDEX(MATCH) to pick up the results.
Does that work for your question?