11 STEPS
1. In this tutorial, we will learn how to create unique filters for data. This can very helpful in edu when examining specific results for Google Forms quizzes or surveys. First, Open your desired google sheet
2. Click the row or column you want to filter. In this case, we selected column K. The, Click Data
3. Click Create a filter
4. You will now see a lined, downward facing triangle dropdown menu within the our column. Click the triangle.
5. You can Filter by values of cells, conditions, or colors. We will filter by condition in this example.
6. Click Filter by condition
7. You now have the option to create very specific filters for data. In this case, we are attempting to see which students agreed with column K's question, so we will click Text is exactly.
8. We will now click value or formula and type "agree" to filter only those students who agreed.
9. Click OK
10. Only answers that "agreed" with column K are now shown. To undo htis, you can always Click Undo (⌘Z) in the top left corner.
11. That's it. You're done!
