THANK YOU! Your XLOOKUP section completely saved me hours of soul-crushing monotony, and made me look good at a temp job. Your short cut videos have also REALLY helped. THANK YOU.. again! You've made a massive difference in my working life, which isn't something I think I've ever said in a youtube comment.
So far, you are the best Excel tutor I have come across on RUclips. Damn! I was struggling with understanding the lookups, although I did ace the mini test but missed the question on vlookup/hlookup/xlookup and how they operate. It led me to search for explanations and I landed on your video here. Awesome stuff.
This was fantastic! Easy to follow and SO SO helpful! I didn’t realize you all of this was possible! Thank you for taking the time to walk through all of this!
Thanks for this video as you have demystified the LOOKUP functions. This is the best 13 minutes I have ever spent on MS-Excel. BTW you got a new subscriber. Thanks for all your efforts!!!👍😀
I was trying to sum some similar headings on different columns , but couldn’t find a solution until watching this video , offset fórmula made it posible . Thanks !!!!
Hi, When we copy an Excel sheet? how add up one to one cell value/ Example the value in cell A1 is 100 by coping the sheet this 100 should change to 101? Thank you if hear a positive Answer
Hey kenji it might be easier to just do a single dual criteria filter function rather than two separate (nested ) filter functions syntax: =filter(array,(criteria 1)*(criteria 2))
For the last example, it might be easier to do a sumifs instead of a nested filter (little cleaner for whoever's coming behind). :) Very informative video!
Regarding the SumFilter sheet, the proposed function "=SUM(FILTER(FILTER(C4:F25,B4:B25=H8),C3:F3=I8))" works great but cannot handle wildcard (at least for me). A solution for this may be "=SUMPRODUCT(--ISNUMBER(SEARCH(I8&"*",B4:B25)),FILTER(C4:F25,C3:F3=I12))" that works well for me. Here we get an array of 0 and 1 based on the results of the SEARCH function (which works with wildcard) by using the ISNUMBER with "--" in front. Then we multiply it by the results of the FILTER function by year and sum using SUMPRODUCT. Cheers
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
👉 Take our Excel Course! www.careerprinciples.com/courses/excel-for-business-finance
thank u coach
hi mate, can you help with Multiple criteria lookup? index match works on some of cells but not others, can you do it with XVLOOKUP?
Heavens! Please dont ever stop making such content.. I learned so much and so effortlessly. Thank you very much Sir!
You are the more complete yet the more simple tutorial that I've seen, straight to the point, thank you.
THANK YOU! Your XLOOKUP section completely saved me hours of soul-crushing monotony, and made me look good at a temp job. Your short cut videos have also REALLY helped. THANK YOU.. again! You've made a massive difference in my working life, which isn't something I think I've ever said in a youtube comment.
So far, you are the best Excel tutor I have come across on RUclips. Damn! I was struggling with understanding the lookups, although I did ace the mini test but missed the question on vlookup/hlookup/xlookup and how they operate. It led me to search for explanations and I landed on your video here. Awesome stuff.
Me too. Kenji has really been able to make it "click" in my mind!
Kenji has a real gift for communicating complex ideas into simple easy to understand language. He is simply the best!
Minus the fact we need to sign up to download his sample file
Thanks!
thank you for supporting Nikhil!
This was fantastic! Easy to follow and SO SO helpful! I didn’t realize you all of this was possible!
Thank you for taking the time to walk through all of this!
I have been watching your videos from a very long time as they are very helpful and easy to understand. Keep up the good work!
Glad to hear that!
Kenji you're an Excel goat, always making things comprehensive and concised, thanks for the video and the quick tips and tricks
Thanks for watching!
Thank you so much! Finally was able to use vlookup to merge data of over a 1000 collums. Saved what would have taken an hour manually
You are the master, the Guru himself. Im so impressed , and subscribed. Watching from Southern Africa.
Omg. You are the super master of explanation. You are the man, the God and the ultimate. ❤❤❤❤❤❤❤❤❤ so beautifully done.
Dear, Your way of explanations, is the easiest on RUclips, thank you so much
the last formula ox xlookup was exactly what i was looking for!
You by far have the best tutorial videos. Thank you for providing so many helpful videos.
This was so precise and to the point. I understood everything you said and appreciated the visual reference. GREAT TUTORIAL!
Excellent! Learning Day by Day Again with Excel thru you YT Channel. Please share more sample worksheets for Industrial Setting.🥰
The last part is the most important for me! Kudos to you for sharing this information🎉
Thank you for sharing this invaluable knowledge. Good things you did will rebound on you.
Nice. More of these, please! Combinations of beast functions
Awesome guide just what I needed. Much appreciate it!
Really appreciated your expertise
One of the Best video on Excel.
Thanks bro, i thought that excel was hard, but you make it so simple to understand and i'm getting better day by day.
Your delivery is top notch. 👌
This is the most helpful video ever. Thank you so muchhhhhh.
Thank you for you clear examples and explanation.👌
Thank you ao much
Amazing 👏.. I've got excited more with excel thank you with this knowledge.
This guy is a gem. Thank you Brother for your efforts.
Thank you for watching!
wow!! Just wow!! you are really amazing!! I didn't know this was possible.
Excellent. 5⭐ description and examples. This will help me so much.
Best and easiest explanation I have seen. Thanks for the content and simplicity!
Bro I love the quality of your videos keep up the good work
Best tutor Ever!!!
This was SO helpful! Thank you so much for posting this video.
Really awesome teaching. Thank You ; )
Thanks for this video as you have demystified the LOOKUP functions. This is the best 13 minutes I have ever spent on MS-Excel.
BTW you got a new subscriber. Thanks for all your efforts!!!👍😀
Thanks to this video, I finally understand how to look up a result in the last situation mentioned in the video. Thank you.
Combining that with data validation is a neat combo for dashboards
Kenji literally explained it like it was nothing. Kudos!
Those very Useful Tips Brother💪
nicely done, you make it easy to understand... now I just have to remember it when I need it :) thx!!
I was trying to sum some similar headings on different columns , but couldn’t find a solution until watching this video , offset fórmula made it posible . Thanks !!!!
Very clean explaning .. Thank you very much for your videos :)))
Glad you like them!
Awesome learning. Thanks for your explanation. This truly helped me to learn xloopup and also filter / sum in a unique way!
Thanks, I liked the most here at Sum-filter part
you really do explain kenji !
Thanks a ton
Great content bro!!
Appreciate it!
great tutorials! Thank you!
You solved a big problem for me. Thanks a lot
Thank you so much Kenji, Excellent function of Filter sum.
Thank you for watching! 🙌
Thank you. Great lessons.
thank you. you always make it look so easy to understand
Damn i always used to change the array arrangement in order to use vlookup. Thanks for introducing xlookup
Thanks, Kenji for the awesome video.
Very well explained
Well-done, your explanation is the best and understandable. Thank you
I will definitely enroll in your excel course. No doubt
I have to second all positive compliments herein 🤜🤛
Hi, When we copy an Excel sheet? how add up one to one cell value/ Example the value in cell A1 is 100 by coping the sheet this 100 should change to 101? Thank you if hear a positive Answer
Thanks!!! I have been looking the last part for long and now I can sleep in peace.
That was smooth. Thank you.
Thanks, Excellent
Glad you liked it!
Thank you... 😀
That's what i was looking for.
Level four 🌟 solved my problem.
Hey kenji it might be easier to just do a single dual criteria filter function rather than two separate (nested ) filter functions syntax: =filter(array,(criteria 1)*(criteria 2))
Haven’t tested it but I think you’re right! Thanks for the info 👏
I knew there had to be a shorter way still.
Whoever you are, thank you for pointing this out. 🙏
Or you can do a single index match formula for that last example, matching the salesperson for the row and the year for the column
@@domaugustus72 This is what i'm also thinking...👌
filter formula was very useful thanks
Nice and Thanks very informative and useful
You are cool! Thank you so much 🧡🧡🧡
Thank you, this was very helpful
The best explanation
For the last example, it might be easier to do a sumifs instead of a nested filter (little cleaner for whoever's coming behind). :) Very informative video!
Amazing videos! You have a new fan 🙋🏼♀️ I was wondering, rather than dragging the formula down, how can I spread it through the entire column?
Pro explainer. 👍
Very useful. Thank you.
Very informative videos as usual kenji , it would be nice if you could make videos based on synergy valuation in m&a in the future?
Thank you for informative videos
V well explained
thank you!
Thanks for the tutorial!
Cheers!
Really comprehensive!! Cheers
Thanks for watching!
Really Amazing
Great content Kenji! Deserving to see next week's video
Amazing video
Excellent. thanks!
Glad it was helpful!
Wow Excellent information...m from pakistan❤
If only one record, use xlookup, if multiple and need total sum, use sum filter. Got it 👍
Regarding the SumFilter sheet, the proposed function "=SUM(FILTER(FILTER(C4:F25,B4:B25=H8),C3:F3=I8))" works great but cannot handle wildcard (at least for me).
A solution for this may be "=SUMPRODUCT(--ISNUMBER(SEARCH(I8&"*",B4:B25)),FILTER(C4:F25,C3:F3=I12))" that works well for me.
Here we get an array of 0 and 1 based on the results of the SEARCH function (which works with wildcard) by using the ISNUMBER with "--" in front. Then we multiply it by the results of the FILTER function by year and sum using SUMPRODUCT.
Cheers
This is very useful. Thanks a lot!
Thanks for watching!
Excellent video! Pls could you do "The ULTIMATE Sum Formulas Guide | SUMIF, SUMIFS, COUNTIF, COUNTIFS"? Thanks!
Great suggestion! will note it :)
@@KenjiExplains Thanks Kenji! I did not know about the XLookup
Cool idea, those are all super useful functions to use!
Love your style of teaching..it wasvesdy to follow and understand
Nice...everyday is a skool day...
Amazing video! Thanks a lot
Glad it helped!
Awesome!
9:59 He felt so sad saying and I can feel his expressions when he said XLOOKUP does have limitations.
I'm trying to find historical values of products purchased from old invoices records and probably XLookup level 4 06:24 would work for me hopefully.
Thank you
Xlookup all the way! 🏆
lets go!
You are really cool
Thank you for the nice explanation❤❤❤❤
Thank you! 😃
Thanks Maestro
I love it...Thanks.