🔥Check out our courses here: www.careerprinciples.com/all-courses
@musamaiza62594 ай бұрын
Your videos makes excel easier for me. Thanks kenji
@sudhansusingh2886Ай бұрын
Thanks Kenji... nicely explained with simple examples. easy to understand. This is helpful.
@m.m.basetolimishkat58463 ай бұрын
Hello Kenji. This is a very helpful video. I am wondering if can we use spin button from the developer tab instead of drop down list. For example: the first spin button will spin Region and the second spin button will spin only those Countries of a Region selected by first spin. Thanks
@vsrkvaraprasadraju49004 ай бұрын
I'm Becoming Pro by learning through your videos 👍
@Meen1828Ай бұрын
Super helpful and easy to follow thanks--
@clayton883904 ай бұрын
kenji the goat!
@KenjiExplains4 ай бұрын
Thank you!
@ianchandley4 ай бұрын
What you said!!! I’m just learning about the AMAZING power of Excel, 30+ years after I first learned Lotus123….. These KZbin videos are a treasure.
@Iriponpal4 ай бұрын
I have learned alot from your videos ❤
@KenjiExplains4 ай бұрын
That's awesome to hear thank you!
@Luciano_mp4 ай бұрын
Very good Kenji. Thank you!
@KenjiExplains4 ай бұрын
Thank you!!!
@foxyturbine71142 ай бұрын
This was super helpful, and a much easier way! Thank you so much!!
@mahmoudmohsen81054 ай бұрын
very informative and simple. Thanks!
@KenjiExplains4 ай бұрын
Glad it was helpful!
@Dmytro8484 ай бұрын
Very useful as always, thank you!
@alexrosen87624 ай бұрын
Excellent tutorial 👌
@NANSOESOESOEKAY2 ай бұрын
My Xlook up correlated data doesn't appear as shown, and it only appears for one data in a cell, not all of its data in a table.
@MuhammadAli-su3oo4 күн бұрын
Can we make our lists in Tables and then apply all the formulas and tricks you used? Tables Lists because if it grows, Table account the changes itself.
@putrakamangpu50334 ай бұрын
Thank you for the very useful knowledge🙏🙏
@michele_alioto3 ай бұрын
by far, this is actually the easiest and fastest way.
@alamiralshafay4 ай бұрын
Great Lecture I like It. Thank you
@KenjiExplains4 ай бұрын
Glad you liked it!
@willzinner88134 ай бұрын
interesting trick thank you
@KenjiExplains4 ай бұрын
Cheers!
@Asma-ep9bx4 ай бұрын
Awesome 👌 thank you very much
@Atifilyas-y9e4 ай бұрын
Thank You Kenji
@KenjiExplains4 ай бұрын
Thanks you for watching :)
@danielhartjes24793 ай бұрын
Nice job!
@camlex63104 ай бұрын
Great video!!
@abubakarrk.conteh3254 ай бұрын
Wow , super cool idea 👍👍👍
@KenjiExplains4 ай бұрын
Thank you!
@coastalb14 ай бұрын
Word of caution. I updated a file with validations for drop downs and used a transpose formula. The file is used by a team in 3 geographically different places, soon to be 4 and must be shared. The transpose formula “breaks” the validation in one column because it is a shared file. Will update it with one of your suggestions to select horizontal selection for the validation. Thanks!
@EMiller5002 ай бұрын
That error check will only work for one particular cell, is that correct? How can I have conditional formatting based on a formula that checks each row, based on the XLOOKUP? In other words, how can I make that "XLOOKUP(D2, ............, E2)" in the conditional formatting formula apply to each of many rows? In your example, it only works on that one cell.
@Abdullah_Alhathloul4 ай бұрын
Very useful
@chidinduuwaeziozi73604 ай бұрын
We could use a custom data validation formula to ensure the right list is always shown instead of simply marking the wrong one
@abdulhamidalhaddadi22554 ай бұрын
thank you its working good.
@KenjiExplains4 ай бұрын
Awesome!
@unwanamiracle43414 ай бұрын
Thank you 😊
@KenjiExplains4 ай бұрын
You're welcome 😊
@mohammadalbizri20134 ай бұрын
Wonderful
@exactltv5570Ай бұрын
Please what if the excel I'm using now does not have XLOOKUP
@EffigyOfAdam3 ай бұрын
Doesn't work on 365. As soon as I get to the second Data Validation list it errors out "This entry leads to an error. Try entering different values to continue."
@sherylsimwunshee26803 ай бұрын
I ran into the same error message. Did you figure out the solution?
@ENDTIMEHOLINESSREVIVALMO-df3xx4 ай бұрын
Hi iam using excel 2016 and always having trouble when making dropdowns instead of words in dropdown go down one by one but instead they are all in one place
@colewest22594 ай бұрын
How would you do a dropdown but with different formulas ?
@avadhuts.227220 күн бұрын
Its not working i am getting named as ERROR how to resolve it
@sreneyАй бұрын
this wont work in MICROSOFT 365. :(
@MrNicho20114 ай бұрын
I have office 2016, =XLOOKUP(... ) isnt availlable, what can i do ?
@XavierSmithSchwazenegger4 ай бұрын
upgrade to 2021 or buy ms365 subscription
@BoooDave3 ай бұрын
You’ll probably have to use index match. In older versions, that’s what was generally used when vlookup wasn’t good enough, so it was essentially the precursor to xlookup. Bit more complicated, but not too bad once you get used to it. Just google index match and you’ll find guides etc easily as it was common practice for a long time.
@sonicanic3 ай бұрын
try indirect and create a name range for each row and refer to it. that worked for my usecace bc i dont need to add rows that often
@richardbeardsley37813 ай бұрын
U can simply use v lookup instead
@mayuronce4 ай бұрын
India🇮🇳❤
@drivensbakoАй бұрын
Thanks for saving my ass
@UtkarshKumar-mp2ls4 ай бұрын
Like always 😂
@KenjiExplains4 ай бұрын
Haha you're on fire! Thanks for supporting always :)
@AbdulAbdul-bu4lr4 ай бұрын
Why must we download a file to practice? Why don't you teach us from scratch?
@KenjiExplains4 ай бұрын
It’s a free file so you don’t have to type all of the values manually as that’s very tedious. Just saving you some time
@nastykitten8970Ай бұрын
i have tried so many fucking goddamn times to do this corerctlhy and i cannot do it and its making me so fucking angry
@abhaymundhra76963 ай бұрын
i am trying to do .this thing in excel online it not happening there like adding new formula to existing one trasnpose is not working help @kenji explains
@fongfongfong19782 ай бұрын
Thank You~~😁💯
@VirenderGupta-h1t4 ай бұрын
I have a question Kenji. Is there any such formula which can automatically separate the amounts of multiple items in one order id in the total amount column? Order ID Product Qty Product Price Payment Mode Cash Amount Card Amount Total Amount 20240520213102 1 995 Card 0 8500 8500 20240520213102 1 799 Card 0 8500 8500 20240520213102 1 6795 Card 0 8500 8500