From the course: Excel: Filtering Data for Beginners

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Filter with a formula

Filter with a formula

- [Instructor] Often people ask, can I filter using a formula? And the answer is yes you can using the filter function. Now, a disclaimer first, right now as I record this, the filter function is in beta but when it's released, it will be available on desktop versions of Excel if you're a subscriber. So, you may not have access to this function yet but I wanted to give you a preview of it so that you know the potential it has. So, off to the side here, I'm going to click cell G2 and I'm going to type =FILTER and then I'm going to press Tab to select that function and now Excel wants me to specify the array, the array that I want to filter and that's this dataset over here. So, I'm going to do a combination of mouse and keyboard to easily target that array, so I'm going to go ahead and click A1 and then hold down Shift and press the right arrow key one, two, three, four times and then I'm going to hold down the CNTRL Shift key and arrow down once and then that will target my whole…

Contents