Like you are teaching computer than human being. I don't have any questions after watching and doing homework's. No any missing point. Thank you again.
Well...there are always something new or cool tricks that I benefit by watching your video...really love the trick of using control key to highlight each column with different heights to define names from selection. It surely saves me time to define them one by one. Nice work, Mike!!
@@excelisfun : I should THANK YOU for making these videos for free!! Whenever people are impressed with my Excel skills, I always recommend them to follow your RUclips channel. You are THE BEST OF THE BEST!!
@@sherryizzie5309 Well, you are welcome! I do appreciate you supporting and telling others about the fun and efficiency here at the excelisfun channel : )
You are awesome! Kudos to you my man. Your videos are extremely helpful in understand just how to work within excel. I'm amazed at just how powerful office is once you get acclimated to using it. Do you by chance have a video on how to format spreadsheets properly so the user/users can print it/them on paper such as a price chart?
Thank you for the video. Question- is there any way that I can automate entering "input message" based on a list of values? e.g. I have three columns 'Field Name', 'Field Value', and 'Field Definition'. I want to show the definition in the 'Field Name' Column itself as an "Input Message" when the cell is selected. Entering one by one in the data validation tab is a time-consuming thing. Any way/formula I can use to get all the definitions in data validation's "input messages" for each field in the list?
very good video! Meanwhile I wonder how one might proceed to avoid the problem of 6. (04:12) Copy and Paste To Wreck Data Validation. your help is much appreciated. thanks!
Great video again. is there a way one can make all pastes "paste values" by default. would avoid the problem of copy and paste destroying data validation ( and other bits of formatting)
Hello Mike, My name is Levente from Hungary, Thank you for sharing your expertise with us, good to see helpful people out there, i have some issue solving a data validation in a invoice sample i am making for my company, i would like to extract or fill from drop down the company data ( name, address vat nr etc from a different sheet) so that i do not have to fill it out all the time, can you please help me in this matter, i would really appreciate it, i am quite new-bee, Thank you in advance for your help, regards, Levente
Mike, is there any difference between your function and this one =countif($B$87:$B$94;B87)=1 for duplicate data in data validation, I think there is no difference, I'm simply curious in your choice
Hi dear teacher, Thanks for your all of efforts in this regards, In list Validations, I got a problem, that when i create lists that contain more than 20 items, when i click on the drop down list i can just see 8 items in each list, how to see all the list and select my choice. Best regards, Abdul Samad Habibi Jalalabad, Nangarhar, Afghanistan 11-Jan-2017
If there was a Nobel Prize for Excel, he would easily win it.
Thanks for your kind words! Thanks too for the support with your Thumbs Up, Comment and Sub : )
that's for sure.
Totally agree with you, I'll vote for him^^
Like you are teaching computer than human being. I don't have any questions after watching and doing homework's. No any missing point. Thank you again.
Great to know from expert master, you are the king of excel kingdom.
+Wagdy Ziada Glad you like the videos!
you are the king of excel kingdom.. you are real guru for Excel
I am glad that the videos help! Thanks for the Sub and Thumbs Up : )
Best explanation on data validation on youtube.
Thanks for your kind words! I am glad that this helps. Thanks for the support with your Thumbs Up, Comment and Sub : )
Great video and great presentation. So much in-depth and thorough!
Glad you like it, Rajan!!!
you are life saver！ thank you for doing this on u tube！！！whenever i have question on excel, you are the man to go to! couldn't thank you any more!
Well...there are always something new or cool tricks that I benefit by watching your video...really love the trick of using control key to highlight each column with different heights to define names from selection. It surely saves me time to define them one by one. Nice work, Mike!!
Glad it helps to save time, sherry izzie : ) Thanks for your great support!
@@excelisfun : I should THANK YOU for making these videos for free!! Whenever people are impressed with my Excel skills, I always recommend them to follow your RUclips channel. You are THE BEST OF THE BEST!!
@@sherryizzie5309 Well, you are welcome! I do appreciate you supporting and telling others about the fun and efficiency here at the excelisfun channel : )
hoo man, you are the best teacher i ever knew, i enjoin learning with your video. thanks a lot for your help. you explain very well and funy.
Glad you like the videos!
Mike: Great explanation. Thanks for remind us about table nomenclature and the indirect with double quotes trick when doing data validation.
+jazzista1967 You are welcome!
Excellent!! especially the last trick with no dups.
best teacher ever! thanks! watch you everyday :)
Great tips! Thank you for detailed informations
You are welcome, Otxan!!! I am so glad that you are learning from this Highline class : )
You are awesome! Kudos to you my man. Your videos are extremely helpful in understand just how to work within excel. I'm amazed at just how powerful office is once you get acclimated to using it.
Do you by chance have a video on how to format spreadsheets properly so the user/users can print it/them on paper such as a price chart?
Thank you for the video.
Question- is there any way that I can automate entering "input message" based on a list of values?
e.g. I have three columns 'Field Name', 'Field Value', and 'Field Definition'. I want to show the definition in the 'Field Name' Column itself as an "Input Message" when the cell is selected. Entering one by one in the data validation tab is a time-consuming thing. Any way/formula I can use to get all the definitions in data validation's "input messages" for each field in the list?
Always interesting even though I saw these ages ago !!! :) :) Thanks.
Yes, and this is the most comprehensive Data Validation video that I ever made... Thanks for watching, John Borg!!!!
This is great. Thank you for the thorough lesson!
You are welcome!
very good video! Meanwhile I wonder how one might proceed to avoid the problem of 6. (04:12) Copy and Paste To Wreck Data Validation. your help is much appreciated. thanks!
Great video again. is there a way one can make all pastes "paste values" by default. would avoid the problem of copy and paste destroying data validation ( and other bits of formatting)
Very good video. Thanks.
Thank again, Mike! Do you have any videos about INDIRECT?
Glad these videos help! Yes, here is one: ruclips.net/video/QWizkfED000/видео.html here is another: ruclips.net/video/fjgFQ-YaOZE/видео.html
Done
Yes!!!!! : ) : ) : )
Hello Mike,
My name is Levente from Hungary,
Thank you for sharing your expertise with us, good to see helpful people out there,
i have some issue solving a data validation in a invoice sample i am making for my company,
i would like to extract or fill from drop down the company data ( name, address vat nr etc from a different sheet) so that i do not have to fill it out all the time,
can you please help me in this matter, i would really appreciate it,
i am quite new-bee,
Thank you in advance for your help,
regards,
Levente
Great video lesson. Tks a lot
+Pedro Cabral da Camara You are welcome!
Mike, is there any difference between your function and this one =countif($B$87:$B$94;B87)=1 for duplicate data in data validation, I think there is no difference, I'm simply curious in your choice
This is great!!!! Thanks a lot!
In Boomerangs example, what if i wanna update the data? Is there any trick for that?
Please let me know.
how do you use a script to format custom colors/format to the data validation input message?
Hi dear teacher,
Thanks for your all of efforts in this regards,
In list Validations, I got a problem, that when i create lists that contain more than 20 items, when i click on the drop down list i can just see 8 items in each list, how to see all the list and select my choice.
Best regards,
Abdul Samad Habibi
Jalalabad, Nangarhar, Afghanistan
11-Jan-2017
Thanks for the tips.
+Samer Debs You are welcome!
If you paste data or drag down ,dups error not shown, it allows, only you type the error message pops up.
Que buen video.
Glad you like it! Thanks for the support : )
Thanks
You are welcome, clifford!!!
Can we customize visual of Drop-Down?
yes bro
Abdul Samad Habib How?
Thank youuu
+Mohamed Chakroun You are welcome!
❤️
I want data validation Like first 4 Letters And last 4 Numbers it should be fix
yf is the most important thing to do with the fact
No dups = no china😂