 In this training video, we're going to look at advanced filtering and using the option copying to another location. So the previous advanced filtering video we copied, we filtered in place and we had the answer down the bottom here that gave us 25. Now I've got the same data, the same scenario and I'm just going to repeat the scenario that I've done on the other video and I'm just going to copy it to another location in this example. So I'm going to set the criteria now for the scenario that I've set here. So sales from France less than 10,000, so France, you can type in any case as long as you spell it correctly and France has to be less than, so arrow to the left, 10,000. Next one's all Spain, so anytime you come down a road it's an all, so I'm writing in the criteria here or Spain, which is greater than or equal to 15,000, so Spain and Spain happens to be greater than arrow to the right are equal to 15,000 or any sales by Hargreaves. So salesperson is going to be Har, Hargreaves or the last one any sales by Harris, which is less than or equal to 10,000, so Harris and Harris has to be less than or equal to 10,000. Just clicking the data, so the data's from A9 down, go to the data tab, advanced and it picks up what's called the list range, we're going to copy it to another location, we're going to copy this example to K1, we're going to make it L1, L1 and I always advise people even if the criteria comes up to reset it in case it changes, so I'm going to delete it and reset the criteria range and I only highlight from the head ends but down to where there's data and I never highlight the blank areas, this is just for additional criteria, click OK and now here's the result of the criteria copy to the location, I can filter it, I can sort this to make sure it's correct, so I'm picking the data, I can sort it on the data tab, in this example I'm going to sort by country and I'm going to go Z to A and then I'm going to sort by another level and then I'm going to go by unit sold and I'm going to go highest to lowest or largest to smallest, click OK and if I look at some of the data, so it's anything by Hargreaves, so it doesn't matter what the value is, there's the Hargreaves, throw out the Hargreaves, spot it throughout, so you can see some of them are UK, some of them are USA, so the UK have to be Hargreaves or Harris because I haven't asked the UK here, so they have to be Hargreaves or Harris and there are and there's a Spain, but you can see pretty quickly that the date is now marrying up as I wanted to work, France down the bottom here, these would all have to be less than 10,000 except it's Hargreaves, so here's a France, big number and that's because of Hargreaves, so we can see quickly how this is working, now you can analyse this further, I could see for example, what's the total sales average, average sales, maximum sales, number of sales, so I'm going to put a couple of headings in here, so you can really start analysing the data now, so total sales, average sales, maximum sales and lots of number of sales, you can always widen the columns like normal, you can double click it, I'm just going to put some format in against these headings, you can do this the format painter, so I'm going to use the format painter, a bit of format in applied and I'm going to left the line, okay now I'll put the answers in, so total of all the sales in this criteria, we can use the autosum, so formulas tab autosum, sum, enter, the average, same idea, autosum again, average, just change the range, I don't include 27, I only want to go to 26, so I'm just going to move it one up, there's the average, maximum sales, same idea again, move it two up, so 28, I want that on 26, a number of sales should be 25, which is what was in the previous video, so count numbers, I only wanted, and you can also change this in the formal bar, I wanted 26, and there's the same 25 as we had in a different example, but this shows you how you can copy an extraction of filter, we use an advanced filter to another location, and it must be a location in the same worksheet, as in this example, but then you can always cut and paste it to another worksheet so you can get around this, you don't have to copy, keep the copy in the same worksheet, you can just do the advanced filter, copy to another location in the same worksheet, and then just cut and paste it to another worksheet, this shows the kind of thing you can do, there we've quickly gone through a scenario, written a scenario, used the data for the advanced filter, got an extraction to start an L1, did a bit of a sort to check it's all correct, and then even analysed it to find that information from it, but this completes the training video on advanced filter, where we've copied to another location in this particular video, 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