When Excel becomes art, Nabil Mourad appears. An exercise in precision and wisdom. Thank you, my friend.
@khanabdussabur8604Күн бұрын
Awesome Nabil! Thanking you.
@Officeinstructor22 сағат бұрын
Glad you liked it!
@Snoop_Doge3 күн бұрын
it never worked for me
@OarN-s6d3 күн бұрын
New
@Officeinstructor2 күн бұрын
Hope it helps
@Rturnerjr13 күн бұрын
Excellent - thank you for your explanation
@therathores4 күн бұрын
Hey great video, very well explained. Can we get this excel for reference? Thanks
@Officeinstructor2 күн бұрын
Thanks for watching. Sorry the exercise file was created for a client and cannot be shared
@meowmeowmeow52024 күн бұрын
Awesome. Can this work if I create one like this in PC and access it in mobile? Thank you.
@Michael_Alaska4 күн бұрын
Well explained, thank you. As Scooby-Doo might say "Rut-Row".
@Officeinstructor2 күн бұрын
Thanks for watching
@kebincui4 күн бұрын
👍👍🌹🌹
@Officeinstructor2 күн бұрын
Thank you
@VijayKumar-zd7ou4 күн бұрын
The way you explain anything is very good
@Officeinstructor2 күн бұрын
Thanks for the compliment
@johnborg54194 күн бұрын
Thanks Nabi.
@Officeinstructor2 күн бұрын
You're welcome
@alializadeh81954 күн бұрын
Thanx
@alializadeh81954 күн бұрын
Thanx
@alializadeh81954 күн бұрын
Thanx
@alializadeh81954 күн бұрын
Thanx
@Officeinstructor2 күн бұрын
Welcome
@reng77774 күн бұрын
Beutiful formulas! thanks for the video!
@Officeinstructor2 күн бұрын
You're so welcome!
@Luciano_mp4 күн бұрын
Beautiful work! Very useful! Very well explained! Thank you very much Nabil!
@Officeinstructor2 күн бұрын
Glad you liked it!
@j4wn5 күн бұрын
I don't have Turn On Bitlocker, I've fallen at first hurdle.
@suhailnbd6 күн бұрын
Nyc
@kbvaldez6 күн бұрын
Saved the day, thanks!
@Gruhayogam905207 күн бұрын
Xlent i never seen in this whole u tube 🙏🏻
@manissery195610 күн бұрын
No one explained Let function with such clarity ever. Thank you so much dear. Give a lesson on Lamda as well❤
@landisk353011 күн бұрын
You saved my day! Big thank you for sharing knowledge
@ikkusoft12 күн бұрын
This is mthe most scientific way of explanation ❤
@artaxerxes_897316 күн бұрын
This did not work is 0ffice 2021
@775shahrukh17 күн бұрын
where is link for practise file.... nabil bhai
@abdallahdataguy21 күн бұрын
Worked for me
@narenderkumararya749822 күн бұрын
Hi Sir, I need your help to resolve my task. i work for a travel agency my management required a how may airline fly the same date same time on the same route and mark it color in pivot table. I work manual this kindly help me on it example on below. Departure Date/Time (Leg) Airline (Segment) Origin Airport Code Destination Airport Code Remarks 2023-10-10 13:25 Lufthansa MUC AMS Duplicate British Airways BOM MAN KLM MUC AMS Duplicate 2023-10-26 02:25 KLM BOM SVG 2023-10-31 02:30 KLM BOM SVG 2023-11-19 08:50 British Airways BOM MAN Duplicate Air France BOM MAN Duplicate
@jonmunnings534722 күн бұрын
Whats the left button i dont see what he clicks to make that appear 😢
@julie_chen25 күн бұрын
👍👍👍🙏🙏🙏🙏💯💯💯🎉🎉🎉
@karsonowsky25 күн бұрын
osom
@Tuesdayable28 күн бұрын
Thank you so much, you are so fast to response ❤❤❤😊😊😊
@dr.mixmatch4561Ай бұрын
guys stuff that has slashes in them like / or even anything with things that windows does not let you name a folder the MD will not make a folder those characters are ( \ / : * ? " < > | ). Also, if there is spaces in between words then it will turn them into seperate folders. Hope this helps
@evilhubertАй бұрын
Thank you kind sir!
@ecarpentryАй бұрын
Doesn't work for windows 11 no bit locker in drop down menu when right clicking drive.
@sushmitashettigarАй бұрын
What if present name and changing name of some sheets are same. I am facing this problem getting debug message that try other method present name is same
@taizoondean689Ай бұрын
Thank you
@DFAntoАй бұрын
This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?
@DPete27Ай бұрын
Be aware that you can still copy paste content into these cells if you start your paste outside the range. ie, if a user copies cells A5:D5, they can paste that range into A6:D6.
@hridyapalАй бұрын
Super easy! Thank you
@user-xv2bu5vt2gАй бұрын
can we do sumproduct on text (strings)? If not then which function to use?
@tonig5601Ай бұрын
Would this work for a shared document?
@niyazfazeenaniyazfazeena1495Ай бұрын
Wow
@amadeuswhitewalker2707Ай бұрын
Thank you sir!!
@ashraf.k.padanilamАй бұрын
Still possible to paste from different file😮
@naeemam7mad786Ай бұрын
hahaha
@Soproni_Larynx_ForditoirodaАй бұрын
FINALLY a useful video! Thank you so much!
@centugurdag7776Ай бұрын
Hi , I love your tutorials, the 2nd method with m code is difficult if you dont master it, the first way with pivot table and array functions is a very nice classic solution with excel , greetings from Turkey Bodrum
@osamamohd007Ай бұрын
Great, thanks for sharing
@IvanCortinas_ESАй бұрын
Excellent explanation Nabil. Thank you my friend!!!
Пікірлер
When Excel becomes art, Nabil Mourad appears. An exercise in precision and wisdom. Thank you, my friend.
Awesome Nabil! Thanking you.
Glad you liked it!
it never worked for me
New
Hope it helps
Excellent - thank you for your explanation
Hey great video, very well explained. Can we get this excel for reference? Thanks
Thanks for watching. Sorry the exercise file was created for a client and cannot be shared
Awesome. Can this work if I create one like this in PC and access it in mobile? Thank you.
Well explained, thank you. As Scooby-Doo might say "Rut-Row".
Thanks for watching
👍👍🌹🌹
Thank you
The way you explain anything is very good
Thanks for the compliment
Thanks Nabi.
You're welcome
Thanx
Thanx
Thanx
Thanx
Welcome
Beutiful formulas! thanks for the video!
You're so welcome!
Beautiful work! Very useful! Very well explained! Thank you very much Nabil!
Glad you liked it!
I don't have Turn On Bitlocker, I've fallen at first hurdle.
Nyc
Saved the day, thanks!
Xlent i never seen in this whole u tube 🙏🏻
No one explained Let function with such clarity ever. Thank you so much dear. Give a lesson on Lamda as well❤
You saved my day! Big thank you for sharing knowledge
This is mthe most scientific way of explanation ❤
This did not work is 0ffice 2021
where is link for practise file.... nabil bhai
Worked for me
Hi Sir, I need your help to resolve my task. i work for a travel agency my management required a how may airline fly the same date same time on the same route and mark it color in pivot table. I work manual this kindly help me on it example on below. Departure Date/Time (Leg) Airline (Segment) Origin Airport Code Destination Airport Code Remarks 2023-10-10 13:25 Lufthansa MUC AMS Duplicate British Airways BOM MAN KLM MUC AMS Duplicate 2023-10-26 02:25 KLM BOM SVG 2023-10-31 02:30 KLM BOM SVG 2023-11-19 08:50 British Airways BOM MAN Duplicate Air France BOM MAN Duplicate
Whats the left button i dont see what he clicks to make that appear 😢
👍👍👍🙏🙏🙏🙏💯💯💯🎉🎉🎉
osom
Thank you so much, you are so fast to response ❤❤❤😊😊😊
guys stuff that has slashes in them like / or even anything with things that windows does not let you name a folder the MD will not make a folder those characters are ( \ / : * ? " < > | ). Also, if there is spaces in between words then it will turn them into seperate folders. Hope this helps
Thank you kind sir!
Doesn't work for windows 11 no bit locker in drop down menu when right clicking drive.
What if present name and changing name of some sheets are same. I am facing this problem getting debug message that try other method present name is same
Thank you
This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?
Be aware that you can still copy paste content into these cells if you start your paste outside the range. ie, if a user copies cells A5:D5, they can paste that range into A6:D6.
Super easy! Thank you
can we do sumproduct on text (strings)? If not then which function to use?
Would this work for a shared document?
Wow
Thank you sir!!
Still possible to paste from different file😮
hahaha
FINALLY a useful video! Thank you so much!
Hi , I love your tutorials, the 2nd method with m code is difficult if you dont master it, the first way with pivot table and array functions is a very nice classic solution with excel , greetings from Turkey Bodrum
Great, thanks for sharing
Excellent explanation Nabil. Thank you my friend!!!