 Hello everyone, welcome back to another video. In today's video, I'm going to be showing you how you can incorporate a wildcard search with the Excel filter function to achieve results such as that we're looking at on the screen now. So as you can see the bottom table is our extensive list of data and the top table is everything filtered. And what we're doing is we're filtering the data based on this wildcard search of shoes. So what it's doing is it's going to take the word shoes and it's just returning all matching items where obviously the word shoes is contained within the item name. So if we had to change this to something like a shirt, you can see how it's now changed the filter to return everything that contains that word shirt. So this is predominantly useful rather than having to provide the exact term. Obviously it allows us to just return all values that match our desired search term. So what we'll do is remove this formula one here and we'll step through how to actually achieve this. So the first thing we're going to be doing is using our good old filter function. So to do that we do equals and then write the word filter and we need to provide obviously the array that we want to filter. So for us, it's our extensive list of data down the bottom here. And then we're going to do a comma and this is where we now need to provide our inclusion logic. So for us we need to first search to see if or find all the applicable items that match our search term or shirt. So to do that we're going to simply go is number, open brackets and then we're going to be using the search function. So the reason for this combination is obviously search is going to search for our word and it's going to do this for each item in our available array. And in essence, what's going to happen is if our search term is found within a particular item, it's going to return the character in which that term appears. So let me see if I can quickly add this one up. So for shirt, we can see we've got polo shirt in the second item here. So what it's going to do is it will say one, two, three, four, five. Shirt appears from the sixth character in our word. And therefore what happens in our logic is says, yes, it's found it because it's identified a character or a number and therefore this logic of is it a number is true. Therefore it meets our criteria. However, in our first item where we've got running shoes, so the word shirt does not appear. Obviously what this is going to do is return an error because it can't find the value we're looking for. Therefore it's not the number and it won't be included in our search term. So hopefully that makes sense to try and explain why we're using this combination. But if that doesn't make any sense to you and you just literally want to know the solution, then obviously we can continue with the video. So what we now need to do is provide our wild card search term. So rather than just saying we want to search for this value, so as we can see in our search function, find the text. Rather than providing just that, obviously it's not going to do anything for us because it's going to look for values or items where the item name is just the word shirt. But we want to find all values where shirt appears somewhere in the item title. So in order to do that, we're going to first do a quotation and then do an asterisk, which you can get by holding down the shift button and number eight and another quotation. And then we're going to do an and symbol and then we will select our search time followed by another and the quotation asterisk quotation and comma. So what this is doing is obviously creating a string for us. It's ultimately creating a value that has the asterisk, our search term and asterisk. And all that really does is it allows the wild card functionality. So it's now going to search wherever this word appears in a product title. And then having done that, we now need to provide obviously the range in which we want to look for our search term. For us, it's going to be in this item column. So we'll select all of that column. And then having done that, all we now need to do is do our closing of brackets. So the first one, obviously, we're closing our search function. The second one, we're closing is number function. And then very lastly, we've got our filter function, which we're closing off there. Once we've done that, we can hit enter and you can see we've now got our desired result for the term shirt. And if you weren't familiar with the filter function, it is one of the newer spill functions. So even though we've put it into just one of our cells, you can see it's spilt literally. To the desired number of columns and rows applicable to the results returned. And from here, all we now need to do is play around as we did at the beginning of the video. So we can now type the word shorts. We can see we've got all shorts or even if we wanted to do something different. So let's say, I don't know, maybe it's a bad one. But we can see we've also got in here the word golf, not going to turn many results. But we can also see that it's going to work for terms like that. So hopefully you found this video interesting. And more importantly, if you were looking for a solution to this particular problem, it's given you just that answer. If this is your first time watching one of our videos or you've watched them in the past and you're still yet subscribed, please can ask you to hit that subscribe button and also why not hit that notification button so you're notified as all of our future videos come out and we try and post daily. So really encourage you to hit subscribe because you're going to get our daily tips and tricks. And lastly, if you did enjoy this video and like I say, it did give you a solution to your problem. Please don't forget to hit that like button. Not only is it greatly appreciated by me because obviously it tells me the content that potentially you'd like to see more of, but it does help that. All important to algorithm and showing that more people will be able to find this video. And lastly, thank you very much again for watching and we'll see you in the next video.