 In this training video, we're going to look at the feature called advanced filtering and using the option in this video called filtering in place. So for advanced filtering, you need an area of data. So we've got an area of data here from A9 down. So here's our data. And you also need a criteria area. Now generally, you write criteria at the top of a filtering area for advanced filtering. So to produce the criteria, you've got to duplicate the data headings as I have here with salesman to unit sold. And you've got to write some criteria here in the blank cells then about what you want the data to look for and to filter for. So we are now going to create a criteria against the scenario here. So this scenario is looking at display the unit sold for sales from France. So for example, France and France has got to be less than 10,000. So I only want to see France from less than 10,000 or sales from Spain, which are greater than equal to 15,000 or any sales by Hargreaves. So there's Hargreaves there or any sales that are less than or equal to 10,000 by Harris. So quite a few bits of criteria there. We'll start from the top and work our way down. So when you write in criteria, you come straight under the headings. And the first one I want is France, the country. So I'm just going to type in France. Doesn't matter if it's capitals or not or sentence, because as long as you type it correctly. So France has to be less than. So less than is the arrow to the left and less than 10,000. Next one in is Spain. So I'm going to go directly below, which is now B3. Let's type in Spain. And Spain has to be, in this case, greater than or equal to. So greater than is an arrow to the right and then equals to is an equal sign. And that's going to be equal to 15,000. Next one is any sales by Hargreaves. So line down again. The line down is an or Hargreaves. And then a line down again or Harris. And Harris has to be less than or equal to 10,000. So less than equal to 10,000. So let's see what this is saying. It's saying criteria France and France has to be less than 10,000. Next one is an or. Or Spain. And Spain has to be greater than or equal to 15,000. Or any sales by Hargreaves or any sales by Harris. And the sales by Harris have to be less than or equal to 10,000. To start the advanced filter off, you click in the data. So just going to click in the data, go to the data tab. Sort and filter section of the ribbon, click advanced. And you've got two options, filter in place or copy to another location. The list range has been sorted. Now this criteria range has been remembered from information I've done previously. So I'd always advise you if you have got previous information in, always to delete it and reset it. If you've never used the advanced filter before, you'll just see the criteria range blank. So I've made it blank again now. I want the criteria range to show me a one. You must include the head ins down to D five. Now, you notice I've got other blank rows. I don't include these. These are only for if I want to add extra criteria. And I can see the name criteria. So there's a name given to these cells. It's called criteria. So there's a named range in place. And now I'm just going to click OK. So that gives me 25. So 25 of 106 happened to hit this criteria. Now you might say, well, how can we prove this? Well, you can start doing some sorts. So I could click in the data, go to the data tab, sort. And then you can think, OK, how are you sort? I mean, you might think, OK, I want to see countries which are what I want to show me countries first in what you might even say, unit sold first. So this is a preference. So I think in this case, I'm going to go unit sold because I've got less than 10,000 here and less than 10,000 here. So I'm going to, first of all, go unit sold and I'll go largest to smallest. I'll go the other way around. And then I'll add another level and then I'll go by country. And I'll add one more and then I'll go by salesman. Let's see how that works. OK, so all the big values I'd have to take as hard grieves because that's anything from hard grieves. Then I get some Spain's and the Spain's have to be greater than 10,000. So there they are there. And then hard grieves, anything by hard grieves. And Morris is a Morris there. That's France less than 10,000. So you can see how a sort can help you actually work through your data. People sort in different ways. This to me makes sense in a way that I would do a sort but sorting is very much preference to how people see the data themselves. So there's a sort but I know I could prove the state to anybody and I know it's been sorted and I know I can prove the criteria against the scenario that's been set and the filtered record is 25 out of 106. In a separate video we will be looking at advanced filtering where we'll copy to another location but this is advanced filtering and filtering in place. That's the example we just covered in this particular video and this completes the training video on advanced filtering and filtering in place. If you enjoyed this video make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.