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!
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
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 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.........
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 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 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.
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 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
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.
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. :)
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
@@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.
Last day someone ask me something like this, I gave her a way almost same as your solution but a little easier for two criteria. It will be smaller formula. =IF(OR(ISNUMBER(SEARCH({"DE","AT"},A5))),"Europe","") Thanks for your training. Mahmoud Baniasadi , from Iran
How do I carry over the exceeding value or the remaining one? For example I have to pay $10,000 but my salary is only $2,100 January is 0 all used and going vacation on february. February is 0 because of vacation and will only receive after I come back (weird company policy) March is 2,100 + 2,100 (paid leave from previous month) + 2,600 (Paid ticket) - 500 (expenses) = $6,300 April 2,100 so on and so forth so 5% of 2100 is 100 for savings. 25% of 2,000 is 500 for daily expenses. 1,500 is can Pay for remaning loan. if 10,000 - 6,300 = 3,700. How can I carry this remaining value to other cell. So that the next month which is 1,500 salary will be deducted.??? Hope you get my explaination.
AH :D that last part is what i really needed. I kept getting the N/A error until i watched the video. Still can't figure out why, but i also tried with IFS and got N/A, so thanks for the lesson !
Beautifully explained Long since I was wondering why the * function doesnt work to retrieve a particular letter while using IF Awesome piece of information
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!
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.
Holy crap!!! That was way more informative than searching through stackoverflow!
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
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!
You have saved my life in excel so many times. Thank you
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.
Leila you are my best excel teacher that i have ever met
Wow, thank you!
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.........
This is my online lecturer of all time...🙏
Be blessed teacher.
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.
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.
Hey Leila have been following you regularly, your online classes made me look like a king before my colleagues at office, thanks a lot!
Thank you... I searched everywhere but no solution... You're a life saver.
Glad to help :)
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.
This is something I've been trying to work out for some time now. Thank you!!!
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.
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.
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 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
I thought I was going crazy, and didn't understand wild cards in Excel. Thank you for the help.👍
Every time I learn something new on this channel.
Great work Leila 👍
You have some of my favourite content in the world. 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.
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!
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.
Thank you so much for your tutorials Leila❤
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. :)
I never tought to use the isnumber function. Awesome Leila. Thank you.
You're very welcome. Glad you like it!
Thank you Leila for these videos. Your explanations are so clear. 😊
I watch your video because you are very nice☺ keep going
Been looking for something like this. This is awesome. Thank you!
You're very welcome!
Never used wildcards before in a formula. Nice video again. Thank you
Can be quite helpful sometimes. Glad you like it Rudolf.
Always you save my projects, Leila ❤
😊
I considered subscribing to this channel
I hope you do. We'd be happy to have you here.
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.
Another excellent video, Leila! Thank you!
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!
I used countif instead of using isnumber and search. Gave same results.
Very useful.. But little bit difficult! love you Leila 😍
Thankyou, I was looking for this formula.
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 :)
It was simple and exactly what I was looking for, even the control + enter was handy!
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.
Saved me hours once again - thanks heaps!
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 :)
You just saved my day. Thank you so so much!!!!
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.
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
Thank you. You made my task really easy.
Great!
Fantastic - elegant solution.
Thank you! Cheers!
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.
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!
Last day someone ask me something like this, I gave her a way almost same as your solution but a little easier for two criteria.
It will be smaller formula.
=IF(OR(ISNUMBER(SEARCH({"DE","AT"},A5))),"Europe","")
Thanks for your training.
Mahmoud Baniasadi , from Iran
How do I carry over the exceeding value or the remaining one?
For example
I have to pay $10,000 but my salary is only $2,100
January is 0 all used and going vacation on february.
February is 0 because of vacation and will only receive after I come back (weird company policy)
March is 2,100 + 2,100 (paid leave from previous month) + 2,600 (Paid ticket) - 500 (expenses) = $6,300
April 2,100 so on and so forth
so 5% of 2100 is 100 for savings.
25% of 2,000 is 500 for daily expenses.
1,500 is can Pay for remaning loan.
if 10,000 - 6,300 = 3,700. How can I carry this remaining value to other cell. So that the next month which is 1,500 salary will be deducted.???
Hope you get my explaination.
@@kurapikanostrad4592 put your input in an excel sheet and send it to me.
N.baniasadi67@gmail.com
You are a life saver Leila
I'm really glad to hear that :)
Very clever. Nice work Leila.
Glad you like it Will.
We are always impressed by your great solutions
I'm glad I can still impress you Réda :)
Hi Leila. Thanks Alot for your videos. They are really helpful.
You're very welcome Eseosa!
Thank you so much for this!
This is Awesome! Thank you Leila!
Thanks Leila from Iraq
this video was so useful and already I started to use it in my report.
You are an absolute magician!!!!!
Excel witchcraft :)
=IF(COUNTIF(A5;"*at*"); ... ; ... ) - BEST CHOICE FOR THIS TYPE OF TASKS!
Thanks Leila👍👌👏. Love you from Iran 😊
Oh my gosh this is EXACTLY what I was looking for!!! THANK YOU!! God Bless!!!
Glad it was helpful!
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...
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 :)
Useful and exceptionally explained! Great thanks for your kind help!
You're very welcome Pankaj! Glad you find the video useful.
Thanks Leila. Another great one.
Nice technique, Leila. That will be very useful.
Glad you find it useful Mark!
Thank you this is very helfful and well explained
This is very useful to me although need some thinking to understand
Awesome Ma'am, Thank you so much.
Nice mam good teaching god bless you...
I'm glad you like it.
Hi Leila,
Very good info, you are a combination of beauty and brains 😊
😘
Thank you for sharing this very useful formula.
Really its great to know thanks for the video . Its very useful .........
Thank u so much Ms. Leila it is really useful video
It can come in handy. Glad you like it Ismail!
Thanks for the trick!
Our pleasure!
Fantastic, thank you for posting Leila..another time saver..
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!
A complex subject very well explained 😊
AH :D that last part is what i really needed. I kept getting the N/A error until i watched the video. Still can't figure out why, but i also tried with IFS and got N/A, so thanks for the lesson !
Thanks, it helped me a lot!
Amazing Video and also replies from viewers
Beautifully explained Long since I was wondering why the * function doesnt work to retrieve a particular letter while using IF Awesome piece of information
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.
Valuable as usual ... thanks Leila
Glad you like it!
Excellent tip!
Thank you, thank you, thank you!
Wonderful tips.
Glad you like it Muhammad.
I was wondering about that for some time. Thanks for the informative video!
You're very welcome.
Excellent. I found this extremely helpful
Liked this lesson
I'm glad to hear this.
Perfection, thank you!