I had to check 7,000 entries of comments (long'ish text) from customers, we were interested in finding a particular word in the comments. Your tutorial here just saved me days of boring 'eye-balling' work, Wonderful! Thank you. BTW, I prefer your style of teaching than many others - it's always clear, no rambling and intuitive. Many thanks again.
I appreciate that you take us through the steps of things that won't work and explain why. This makes it easy to follow and is useful for cases where those functions that don't work in this case might be useful for something else we encounter in the future. Thank you for your work on this!
i was looking over 4 weeks for this formula in the internet and suddenly youtuve recomends me this video and you gave me the solution i finnaly needed thank you so much
Wow......I am very thankful to you Leila........I have applied the same to my worksheet and it really works........your tutorials save lot of man hours........thanks once again.........
That awesome moment you come to see a Leila video because the title tells you this is going to be useful, and it is a formula that you use almost daily at your job. Feels amazing
When I saw this video few months ago, I didn't remember much of it. Until I had to do something similar in DAX. Now when I check your video out again, I just realized whatever I watched had entered my subconscious! Yay. Keep posting these great contents, Leila.
I really get the excel formula thing here. Straight to the point not complicated and I understand it to express it in my own words. I have been to the the other guru sites as known - but here I have more satisfaction in learning, I should have come here first!
I had to display list of values based on partial match of text in the previous column cells. This helped me resolve an issue which I was struggling for days. You are awesome. Thanks ! For anyone who is new in Excel, this channel is good info here.
I have been looking for something like this for probably over an hour, and you managed to solve my problem within the first 11 seconds of this video. I literally cannot thank you enough TuT
Sincerely, the method of leila is better than your method...!! with your formula, you can not search for a number in a series of digits, unless the cell contains a combination of numbers and text
I find your explanations and applications to be the best. Even when I delve into some obscure situations you have answers that work. Thank you so much for your postings.
I freaking love you!! I consider myself excel literate but sometimes I struggle trying to make an argument work. So its like 'Hey, I wonder if Leila knows.' BAM! There it is. I am subscribing to everything you do. :)
Hey Leila. I've used the isnumber function for this too but I think you can also do this with the If function along with a match since the match allows for the asterisks wildcards. Then if the match works you can use the if conditionals.
@@LeilaGharani Other you tube tutorials was difficult to understand or sounds was not clear to hear. Your lesson is easy to understand, very comfortable and very practical. I subscribed you and start watching every video. Really appreciate your effort and reply.
Hi Leila.. cool solution. First I used IF with SEARCH and then wrapped the IF with IFERROR which trapped for #VALUE! when no match was found by SEARCH. Your method using ISNUMBER is more logical and I prefer it. Thanks for the insights on how to do partial match with IF using ISNUMBER, SEARCH and OR.. great stuff! Thumbs up!! PS - I also like the COUNTIF solution below by Alpha State and others.. always nice to see multiple ways to solve the problem.
Great video, what about if you had different kinds of fruits listed and want to know which fruit had a quantity sold is less than half of its initial quantity
Mam I had solved many Excel problems with your Excel tutoring, I had started to learn Excel formula with your Excel tutoring , Thank You for that Now I had a problem that I can not use the index and match function Merged cell please give me a solution to this Mam at first I was entertaining to the company I don't know anything about Excel Formulas, I had started learning Excel Formulas with your Excel tutoring and then I was shining in my company Thank You for that Mam I am expecting you may give me a very good solution to this problem Thank you Mam
Thanks mam you have just made it simple.....I wasn't having answer to this question why wildcard isn't working after if.....now I can die peacefully...😆.... thank you so much mam.
Grab the file I used in the video from here 👉 pages.xelplus.com/if-wildcard-file
I had to check 7,000 entries of comments (long'ish text) from customers, we were interested in finding a particular word in the comments. Your tutorial here just saved me days of boring 'eye-balling' work, Wonderful! Thank you. BTW, I prefer your style of teaching than many others - it's always clear, no rambling and intuitive. Many thanks again.
I appreciate that you take us through the steps of things that won't work and explain why. This makes it easy to follow and is useful for cases where those functions that don't work in this case might be useful for something else we encounter in the future. Thank you for your work on this!
You're very welcome Brian. I'm really glad if I can provide some useful alternatives.
@@LeilaGharani THANKS! But there is other variant how to say "contains" : =IF(COUNTIF(A5;"*at*"); ... ; ... ) - BEST CHOICE FOR THIS TYPE OF TASKS!
Holy crap!!! That was way more informative than searching through stackoverflow!
i was looking over 4 weeks for this formula in the internet and suddenly youtuve recomends me this video and you gave me the solution i finnaly needed thank you so much
Great, I'm glad I was able to help with that Sven!
Wow......I am very thankful to you Leila........I have applied the same to my worksheet and it really works........your tutorials save lot of man hours........thanks once again.........
That awesome moment you come to see a Leila video because the title tells you this is going to be useful, and it is a formula that you use almost daily at your job. Feels amazing
Happy to hear that! Thank you for your kind comment Meli.
Thanks!
Thank you! Glad the video was helpful.
Leila you are my best excel teacher that i have ever met
Wow, thank you!
This is my online lecturer of all time...🙏
Be blessed teacher.
Hey Leila have been following you regularly, your online classes made me look like a king before my colleagues at office, thanks a lot!
You have saved my life in excel so many times. Thank you
When I saw this video few months ago, I didn't remember much of it. Until I had to do something similar in DAX.
Now when I check your video out again, I just realized whatever I watched had entered my subconscious! Yay. Keep posting these great contents, Leila.
Oh wow, I didn't know my videos had such an effect :) Glad you find the tutorials helpful Alex.
@@LeilaGharani ma'am I'm from India and you
I really get the excel formula thing here. Straight to the point not complicated and I understand it to express it in my own words. I have been to the the other guru sites as known - but here I have more satisfaction in learning, I should have come here first!
Thank you for the kind feedback. I'm glad you like the style of the videos.
I had to display list of values based on partial match of text in the previous column cells. This helped me resolve an issue which I was struggling for days. You are awesome. Thanks ! For anyone who is new in Excel, this channel is good info here.
WOW! knowing this channel is like seeing water in the mids of the hot desert. Thank you, Laila. Much love!
Thank you very much for the kind words Abubakar! I'm glad you like the videos.
I have been looking for something like this for probably over an hour, and you managed to solve my problem within the first 11 seconds of this video. I literally cannot thank you enough TuT
Glad I could help
Thank you... I searched everywhere but no solution... You're a life saver.
Glad to help :)
This does the job as well:
=IF(COUNTIF(A5,"*AT*")>0,"AT","")
This one is amazing, because it's works also with "?" wildcard.
Thank you for this! :)
This is Good one 👍
I LIKE this! Thank you for sharing : )
Nice. It works like this as well: =IF(COUNTIF(A5,"*AT*"),"AT","")
Sincerely, the method of leila is better than your method...!! with your formula, you can not search for a number in a series of digits, unless the cell contains a combination of numbers and text
You saved my life.... THANK YOU!! I was looking for a formula like this for soooo long.
Every time I stuck why is it always your videos that is most useful? :)) thanks soo much.
I find your explanations and applications to be the best. Even when I delve into some obscure situations you have answers that work. Thank you so much for your postings.
I used search with wildcards and its results are magic... Good to see the same in your video...
Agreed, it can really be helpful sometimes.
@@LeilaGharani i used it creating reminders, will share with you once its done.
Great! Looking forward to it.
Thanks Leila😊
Once again, you show a learning video that's easy to understand for everyone👍
You're very welcome Peter! Glad it comes across like that.
This is something I've been trying to work out for some time now. Thank you!!!
I freaking love you!! I consider myself excel literate but sometimes I struggle trying to make an argument work. So its like 'Hey, I wonder if Leila knows.' BAM! There it is. I am subscribing to everything you do. :)
Every time I learn something new on this channel.
Great work Leila 👍
Always you save my projects, Leila ❤
😊
This was exactly what I was looking for and I was able to write my formula with IF + wildcards and it solved my problem. Thank you!
Hey Leila. I've used the isnumber function for this too but I think you can also do this with the If function along with a match since the match allows for the asterisks wildcards. Then if the match works you can use the if conditionals.
Thank you so much for your tutorials Leila❤
Been looking for something like this. This is awesome. Thank you!
You're very welcome!
I thought I was going crazy, and didn't understand wild cards in Excel. Thank you for the help.👍
You have some of my favourite content in the world. Thank you
I watch your video because you are very nice☺ keep going
Never used wildcards before in a formula. Nice video again. Thank you
Can be quite helpful sometimes. Glad you like it Rudolf.
I considered subscribing to this channel
I hope you do. We'd be happy to have you here.
Fantastic - elegant solution.
Thank you! Cheers!
Very clever. Nice work Leila.
Glad you like it Will.
Thankyou, I was looking for this formula.
I never tought to use the isnumber function. Awesome Leila. Thank you.
You're very welcome. Glad you like it!
Very useful.. But little bit difficult! love you Leila 😍
Saved me hours once again - thanks heaps!
Very helpful, but so too was that little reminder about filling without formatting at 4:44 - I hadn't realised you could do that. So thanks twice!
You're very welcome Terry. I'm glad it was useful twice :)
You are a life saver Leila
I'm really glad to hear that :)
You are an absolute magician!!!!!
Excel witchcraft :)
Thank you Leila for these videos. Your explanations are so clear. 😊
You do a phenomenal job at explaining how to use Excel Leila. Please keep up the good work!
Thank you for the kind feedback. I'm glad the tutorials are helpful.
This is really I was looking for. Thank you.
Glad I could help!
@@LeilaGharani Other you tube tutorials was difficult to understand or sounds was not clear to hear.
Your lesson is easy to understand, very comfortable and very practical.
I subscribed you and start watching every video.
Really appreciate your effort and reply.
I thoroughly enjoy watching your videos. Very informative and practical. This is stuff you can actually use in real-world applications. Thanks!
Really glad to hear that Mike. Thanks for the feedback.
This is Awesome! Thank you Leila!
You just saved my day. Thank you so so much!!!!
Leila - Thank you for all the Excel videos. They are all so helpful and I have enjoyed every one so far. Please don't stop.
I'm glad to hear that and don't worry Dustin. I'll keep them coming :)
Thanks Leila. Another great one.
Another excellent video, Leila! Thank you!
Thank you so much for this!
Thank you. You made my task really easy.
Great!
Really nice video. Quite helpful.
I was looking for this formula 😍 thanks alot Leila :)
You're welcome 😊
@@LeilaGharani I am facing an issue, if instead of Europe i want "AT" or "DE" to come how can i do that. Thank you in advance :)
Hi Leila can you please guide me on this too :)
Hi Leila.. cool solution. First I used IF with SEARCH and then wrapped the IF with IFERROR which trapped for #VALUE! when no match was found by SEARCH. Your method using ISNUMBER is more logical and I prefer it. Thanks for the insights on how to do partial match with IF using ISNUMBER, SEARCH and OR.. great stuff! Thumbs up!!
PS - I also like the COUNTIF solution below by Alpha State and others.. always nice to see multiple ways to solve the problem.
Exactly, that's why I really appreciate comments :) Thanks for the thumbs up!
Gr8
You are a SOLUTION to any issue in Excel.
Tons of Permutation n c Combination can be worked with your this invention.
Thnx
Thanks for the kind words Shabbir. Glad you like it!
We are always impressed by your great solutions
I'm glad I can still impress you Réda :)
Great video, what about if you had different kinds of fruits listed and want to know which fruit had a quantity sold is less than half of its initial quantity
Thanks Leila from Iraq
Mam I had solved many Excel problems with your Excel tutoring, I had started to learn Excel formula with your Excel tutoring , Thank You for that
Now I had a problem that I can not use the index and match function Merged cell please give me a solution to this
Mam at first I was entertaining to the company I don't know anything about Excel Formulas, I had started learning Excel Formulas with your Excel tutoring and then I was shining in my company Thank You for that
Mam I am expecting you may give me a very good solution to this problem
Thank you Mam
I used countif instead of using isnumber and search. Gave same results.
It was simple and exactly what I was looking for, even the control + enter was handy!
Thanks for the trick!
Our pleasure!
Awesome Ma'am, Thank you so much.
Nice mam good teaching god bless you...
I'm glad you like it.
Awesome video and a good tip of the IF function. Thanks Leila we appreciate you so much. please, keep up with the great work.
You're very welcome. It can come in quite handy sometimes.
Excellent Video -- informative, clear, concise script. Good camera work, good sound, well paced and edited. Very well done! Thank you!
You're very welcome. I'm glad you like the quality of the video!
Amazing Video and also replies from viewers
Another great video.
Glad you like it Walter.
Is there a way to use {…,…} in place of typing out the search function twice? The only thing that is really different is the criteria.
Thanks Leila👍👌👏. Love you from Iran 😊
this video was so useful and already I started to use it in my report.
Thanks, it helped me a lot!
I definitely want to be your stud Leila, thanks for the quality of content you put in your videos...
You're very welcome. Glad you like the videos Remila.
@@LeilaGharani absolutely in love I can't wait to get in office to put all that on a worksheet, thanks again and keep up...
Hi Leila,
Very good info, you are a combination of beauty and brains 😊
😘
Useful and exceptionally explained! Great thanks for your kind help!
You're very welcome Pankaj! Glad you find the video useful.
Hi Leila. Thanks Alot for your videos. They are really helpful.
You're very welcome Eseosa!
Nice technique, Leila. That will be very useful.
Glad you find it useful Mark!
you are the best 👍
Thank you, Leila 🙏
What if is search for a date instead "AT"?
Wonderful tips.
Glad you like it Muhammad.
Liked this lesson
I'm glad to hear this.
Perfection, thank you!
Thank you, thank you, thank you!
Very smart. Thanks Leila
You're very welcome. Glad you like it.
A complex subject very well explained 😊
Valuable as usual ... thanks Leila
Glad you like it!
Very useful, Thanks Lelia as always u Rock...😍
Glad you like it!
This is very useful to me although need some thinking to understand
Thank you Leila. I have been stuck for more than a month now trying to configure how to handle this...can i get the formula version for power query?
Fantastic, thank you for posting Leila..another time saver..
Absolutely awesome!!!! Saved me time!!!!
Thanks mam you have just made it simple.....I wasn't having answer to this question why wildcard isn't working after if.....now I can die peacefully...😆.... thank you so much mam.
Thank you for sharing this very useful formula.
Thank u so much Ms. Leila it is really useful video
It can come in handy. Glad you like it Ismail!