I have my user data up at the top.
Down at the bottom is a filter that I've done already. So, the first thing you are going to see
is that there's no little arrow with a drop down.
that contains different ways to filter and sort like if you're using a filter in Excel.
and it's also just done in the cell, E9.
If I delete E9, E10 is a function of that,
even though it looks like it typed in. So, I'll delete E9
hit enter and E10 goes away also because that
was a result of the formula.
There is two ways to get this going. One is to
press the Fx, which is the function button.
You'll get a list of all of the functions.
Filter is at the top just because I used it recently, but you would find it by
looking in alphabetical order. Press filter.
Then you select filter here.
That pre-populates your formula box with
the word FILTER. Now we are going to tell it
what the range is. First, we are just going to do it
on the first column. So, let's do E4:E6.
That's saying, "Hey Google Sheets, I want
filter the data that's in E4 to E6
which is also shown by this red rectangle.
Now that you're working on a tablet, you can - this is dangerous because it sometimes
misbehaves for me, but
if I take my finger, obviously you can't see my finger,
because there's no mouse, and hold down the red square
in the lower right hand corner of the rectangle
I can drag it to the right.
That automatically changes my range.
Much like you would use a mouse. But, I am going to drag it back.
I am going to use a comma. The condition is
let's say I am going to filter for everything that is greater than 1.
You have to retype the range.
So it know what you are operating on.
So, that range, then greater than one.
I'm done! I am going to hit enter.
Awesome!
Let's see why that didn't work.
I am not sure. Let me delete it.
Redo it.
= FILTER. By virtue of that not working, I am just going to show you the second
method which is just to type it.
The range again is E4:E6.
Let's say the condition is that
E4:E6>1
Done. Enter.
It decided to work that time.
Now, you're watching the video so you can probably tell what I did wrong
but I'm not sure.
So that's a simple filter on
one set of data.
One column.
Let's see what we want to do for two columns.
I am going to delete this in A9.
It's also going to delete A10 because that's a result of what was in E9.
Here I am going to do filter
and I'm going to say on E4
all the way over to F6.
And my condition here is going to be
if F4:F6
is equal to AA.
Hit enter, and it should give me - before I hit enter
since I am doing both columns, I would expect the answer to contain both columns.
but I am just applying the criteria to column F.
so it is going to do which ones match column F
but give me both columns.
I can see right now as I am talking that I want a single A.
Now that that's fixed, I am going to hit enter.
And viola! That's what we expected so that's good.
Let's do one more thing.
Let's do multiple criteria.
We're going to come back into this formula and I am going to say two conditions, muiliple conditions
For this one, I am going to say
E4 to E6 equal to 2
I don't need the quotes because
2 is a numerical value. You need the quotes on text.
That's why the qoutes are around the "a".
It should redo this live, kind of the same way
as if you were clicking the drop down menus for the filter function on a desktop or laptop.
There we go, it redid it live.
It only changed the formula in E9
If you look in F9, there is no formula.
That little 2 popped up there again. I don't know why that's popping up again.
I'm going to delete it.
That's an overview of the filter function.
It's there, it works.
I don't think it's nearly as useful as doing it on a desktop because a desktop
let's you look at things on the fly. That's why you use filters.
I just click it, and I click another, etc.
That's a lot clunkier to do
when you are typing it in.
But, that's the state of Google Mobile Sheets right now.