Great video. I learned recently how to add a nice touch to interactive graph titles so that they retain formatting of the value shown. In the case of the sales total, the formula can be modified as follows: =B9&" total - "&TEXT(C9,"$#,###") This will allow the figure to be shown in currency format. Cheers
XLOOKUP has opened a new sea of possibilities and has also many short comings of previous look up functions in previous Excel versions. Thanks for this brilliant video Alan :)
Hi Alan.. awesome! Thanks for the many examples. XLOOKUP can really stand in for a lot of the old functions.. and make life so much simpler. Love the nested XLOOKUP/XLOOKUP for two-way lookup and the concatenated lookup_value and lookup_array examples.. brilliant! Thanks for sharing your tips and tricks. Thumbs up for Computergaga!!
Thanks, great video! With the ranking of the top 5 products, what if two products have the same value? How can get it to return each result not just the first result?
In the video example #3 Ranking the top five items by sales xlookup works great if all the sales totals are different. If one or more are the same xlookup does not work. I have thought about and tried different approaches but I have not found a solution. I am hoping that there is an easy solution because I think xlookup is great function. Thank you.
Yes, ranking values is always interesting. I have a video solving your question here Dale - ruclips.net/video/sk3z8e2mvng/видео.html But I could make 20 of these. Because there is always the question of, if there are tied values, how should we rank them. What decides who is higher in the list, or how to rank them equally.
Awesome. Number 6 is exactly what i needed. I had a work around in place but had to use a helper column to concatenate my data. This does exactly what need. thanks!
Hi Alan, for example 3 Ranking, how do I tweak the formula to accommodate products with exact sales number? E.g. If Carrot Cake and Chocolate Brownie are having sales of 126, how do I tweak the formula so both results can be shown? Thanks!
Hi can you help with counting entries between time but same date, example: wanted to count how many cars came in between midnight 00:00 am to 06:00 am morning. I'm looking for a simple formula
@@Computergaga thank you for your reply. Unfortunately I have tried that too but no luck. Also wanted to let you know that I'm using formula to register the time automatically when a car enter i only type the registration number and time comes. So if you know any other formula that would work with formula then it help.
Can you help me I watch you videos but I am stuck. Can you show how to move rows to another sheet if a criteria is met. What I am trying to do is create a sheet where outstanding balances are greater than zero. I am using excel 2011
You are an excel Rockstar: Alan, not only can you spin yarn and expand the universe but also are a culinary connoisseur (cheesecake is far superior to apple strudel). Also two xlookups you've gone too far. Thanks for all you do.
I must say its best video on Xlookup on YT.. Thanks Buddy
Wow, thanks!
Great video. I learned recently how to add a nice touch to interactive graph titles so that they retain formatting of the value shown. In the case of the sales total, the formula can be modified as follows: =B9&" total - "&TEXT(C9,"$#,###")
This will allow the figure to be shown in currency format. Cheers
Instructive as always!! One of the best excel channels on YT!
Thank you. Much appreciated 😀
Amazing the universe of options now opened with XLOOKUP. And wonderful that we have somebody like you sowing it to us. Thank you very much.
My pleasure Angelo. Thank you.
XLOOKUP has opened a new sea of possibilities and has also many short comings of previous look up functions in previous Excel versions. Thanks for this brilliant video Alan :)
Absolutely. Thank you Sachin.
Example 5 is exactly what I was looking for - thank you! Cheers mate!
My pleasure, Jared. Great to hear.
Hi Alan.. awesome! Thanks for the many examples. XLOOKUP can really stand in for a lot of the old functions.. and make life so much simpler. Love the nested XLOOKUP/XLOOKUP for two-way lookup and the concatenated lookup_value and lookup_array examples.. brilliant! Thanks for sharing your tips and tricks. Thumbs up for Computergaga!!
Thank you Wayne.
really great Tutorial.
Thank you, Ishan.
Thank you so much for this video! Awesome and so helpful.
You're welcome, Petra. Thank you.
great Alan
Thank you 😊
Thanks, great video! With the ranking of the top 5 products, what if two products have the same value? How can get it to return each result not just the first result?
Very good video and examples. Well Done!!
Thank you, Dale.
That's very rich and awesome, thanks Alan .
My pleasure. Thank you.
Thanks for example 👍👍
You're welcome Muhammad.
top quality channel this, thanks very much
Thank you very much Jonny.
Awesome Tutorial Really Helpful!XLOOKUP Certainly A Cool Function!Thank You Alan :):):)
My pleasure Darryl. Yes, it is fantastic.
very good !
Thank you.
awesome tutorial
Thank you Kalyan.
Goood...Thank you Alan!
Thank you Luciano.
In the video example #3 Ranking the top five items by sales xlookup works great if all the sales totals are different. If one or more are the same xlookup does not work. I have thought about and tried different approaches but I have not found a solution. I am hoping that there is an easy solution because I think xlookup is great function. Thank you.
Yes, ranking values is always interesting. I have a video solving your question here Dale - ruclips.net/video/sk3z8e2mvng/видео.html
But I could make 20 of these. Because there is always the question of, if there are tied values, how should we rank them. What decides who is higher in the list, or how to rank them equally.
Awesome. Number 6 is exactly what i needed. I had a work around in place but had to use a helper column to concatenate my data. This does exactly what need. thanks!
It is great isn't it. Thank you Von.
Hi Alan, for example 3 Ranking, how do I tweak the formula to accommodate products with exact sales number?
E.g. If Carrot Cake and Chocolate Brownie are having sales of 126, how do I tweak the formula so both results can be shown? Thanks!
This video will show a way my friend - ruclips.net/video/sk3z8e2mvng/видео.html
Hi can you help with counting entries between time but same date, example: wanted to count how many cars came in between midnight 00:00 am to 06:00 am morning. I'm looking for a simple formula
You can use the COUNTIFS function. Depending on your spreadsheet you could use a formula such as =COUNTIFS(A2:A11,">="&D2,A2:A11,"
@@Computergaga thank you for your reply. Unfortunately I have tried that too but no luck. Also wanted to let you know that I'm using formula to register the time automatically when a car enter i only type the registration number and time comes. So if you know any other formula that would work with formula then it help.
Can you help me I watch you videos but I am stuck. Can you show how to move rows to another sheet if a criteria is met. What I am trying to do is create a sheet where outstanding balances are greater than zero. I am using excel 2011
You could use a PivotTable with a filter set for >0.
Thank you for the video. Download link is dead.
You're welcome, Ezel. Download link is fixed.
Hi,
i am using Office 365. in my PC Xlookup function is not working. can you please help? Thanks
You don't have it? Try running an update, or switch to the Monthly channel. Instructions on how to do that here - bit.ly/2G8qHhx
@@Computergaga thanks a lot. unfortunately i don't have admister rights to do it. but at least now i know how to do it.
You are an excel Rockstar: Alan, not only can you spin yarn and expand the universe but also are a culinary connoisseur (cheesecake is far superior to apple strudel). Also two xlookups you've gone too far. Thanks for all you do.
😂 My pleasure. Thank you Rob.