Bhai mein excel mein ZERO tha,but apke vedio dekh dekh kr accha excel operate kr leta hu...Uppr wala aapki umar lambi krein,aur hum jaise logo ko sikhate rhe,mere pass fee k paise nhi hote the computer sikhne k liye .jab main student tha,but ab aap jaise bhaiyo ki wajah se hi sikha h,jo kuch bhi aata h...thanks a lot...may God bless u
Sir, can you please help me regarding a particular data validation topic, if the data is such that the first five characters will be alphabets only (A to Z) Sir, I can not use the istext function because istext function considers special characters also as text only. So how can I ensure that only alphabets are entered and not any thing else ? Sir, one more question, is there any function for special characters like isnumber or istext ? Thanking you
Deepak bhai the way of yr teaching is very unique n excellent lot of things n formulas have learnt from u , i drsire to know how v can put the specific numbers in a specific text that always indicate with that text ..... thank
sir the video is very useful . . i have learned so many things. i am a teacher. kindly tell me about which type of questions are asked in advance excel interview
Sir, You have excellent explaining skills. Your videos are very helpful for my day to day work in office. I have encountered a doubt. The validation cell/column is ignoring the validation when pasted other data. The cell should prevent and say that "the value you entered can not be allowed". Plz. clarify. Regards.
Nyc sir..👍 Aapki sari video superb h....👏 But mera bhi 1 *questions* h ki Sir jb text & numberic value 1 saath ho.. --> as232mf56df8 Agr aisa format ho to kya formula lagega ? Plz solve & Send video..🙏
Great tricks........on the line... Sir can you new file....... " Condition formatting & consolidate sheet ..........," Plz make it.............. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
I really really appreciate with your explanation and very much clarity. Thanks for you effort and knowledge sharing. But, I have a question, In case if user wan't to enter the character like CRC0002001, CRC0002002 etc. Its like your company code, employee code or anything similar. Can we do this using data validation or we have to use VBA.
Sir ,welcom, deta entry ka kaam main jo heading hota hai usko requirment ke hisab se make karna parta ha ya apne se khud heading banana parta hai ek videos main deta entry ke headin ke bare main video banaye kya kya aur kaisa kaisa heading hota hai plzzz explain it Ok thanks sir
Please make video on How to make a monthly report on bills prepares in a month and at the end it show total amount of all bills and if there is any correction in any bill it will automatically update in report.
Sir I want to know if data is in row position some data in below row but 1st 4 col blank & same in remaining row as it's and I want a data in another sheet except 1st row data wants & come out from 3rd row col no.6 ka data out come in another sheet lookup value in 1st row like 1st row and 1st col.
Hello sir i liked your all tutorials. And i have one question to ask that is i have 10 alphanumeric values in first column and on the second column i want to enter some values but there should be a condition that is.It takes or enter only between that 10 alphanumeric values which are given in a first column. And Can't take duplicate values or can't take double enter of any values which are present in a first column.
Nhi sir mean k hm aik aisa validation rule bnana chahey jis mai alphabets or numbers k ilawa or kuch agr hm apni file mai enter krna chahey tu wo excel hmey error dai dai
Sir man lijiye ki mob. No. Do types ke h, ek 7 digit ka or ek 10 digit ka toh aise condition me kaise is formula ko update krenge.. mtlb mob. No 7 digit ka accept kre ya fir 10 digit ka.. dono ke bich ka bhi digit accept na ho? I tried by using "OR" in the place of "AND" but it didn't work
(?) hi bro , and len furmala is working only if we select one cell iit is not working on column of 12 cell, but if wee drag thatt one cell than it is working , can you please tell me how this and len formula working on multiple selection at one time . because i have tried this on 1 cell than its working , but when i gave it range of (a2:a12) than this formula is not working . please reply me.
Kya kisi work sheet ya kisi cell ya kisi row ya collom me esa kuch kiya ja sakta he ki usme kisi bhi case me likha jaye vo automatically propper ya upper ya lower case me convert ho jaye ??
Hi bro How r u, hope you are well. I have a doubt. How to set automatically sms or message to WhatsApp in excel if due date completed? Kindly advise to me.. Thanks
Just write blood groups in a column.. Copy them.. Go to data validation.. Choose list.. And in the source box.. Paste them.. All done.. Now in selected range.. You can only select bloodgroups from dropdown
Sir lekin meye istext function use Kar raha hu aur cell meye "a123abc" lekh rakha hu Tb accept Kar raha hai ..tab Koi error msg show Nahi Kar raha.. Sirf only alphabet ke leye kya Karna hoga... Please help...
सर एक ऐसा वीडियो चाइए जिसमे मैक्रो रिकॉर्ड करके डाटा 2एनडी शीट पर जाए, लिकिन वह एंट्री तभी हो जब सभी सेल फिल है अन्यथा एंट्री ना हो। सर प्लीज बना दीजिए।🙏🙏🙏
Sir ji, Namste Sir ji meri ek word office 10 ki file hai jis pe password lga hai mai usk a password bhul gya hu uska password kaise remove hoga aur data bhi safe rakhana hai Please guide sir ji
Ky text or number ka validation dono ek sath use kr skta h example pan card number 10 digit ka hota h 6 text or 4 number to muje ek call ye validation lgna h ki mera text na to 6 se jada ya km or number 4 se jada ya km na ho
![Data Validation In Excel [ Hindi ] - Using Data Validation on Date, Time & Text Length](http://i.ytimg.com/vi/VjVpMVO8Jq0/mqdefault.jpg)
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Sir,you are teaching very well.
Thanks a lot sir.
Bhai mein excel mein ZERO tha,but apke vedio dekh dekh kr accha excel operate kr leta hu...Uppr wala aapki umar lambi krein,aur hum jaise logo ko sikhate rhe,mere pass fee k paise nhi hote the computer sikhne k liye .jab main student tha,but ab aap jaise bhaiyo ki wajah se hi sikha h,jo kuch bhi aata h...thanks a lot...may God bless u
Sir, can you please help me regarding a particular data validation topic, if the data is such that the first five characters will be alphabets only (A to Z)
Sir, I can not use the istext function because istext function considers special characters also as text only. So how can I ensure that only alphabets are entered and not any thing else ?
Sir, one more question, is there any function for special characters like isnumber or istext ?
Thanking you
Sir apki video very knowledge wali video hai or apne video me bhot easly explain kiya hai thanku sir
Thanks sir
Aap hr option Bahut achhi tarah se clear krte hai
namstey deepak sir ji aapke saare videos maine dekhe, sach mai mujhe excel nahi aata tha, lekin videos dekhne k baad mujhe excel aa gaya. thanks
Aapka Explain Karne ka tarika bahut acha hai. Aapka ye video muje bahut acha laga. Thank You deepak bhai.
+Pankaj Patil :)
Deepak sir very very nice . You are a great teacher the method of teaching is very very good
Bhai tu bhot acche se smjhata h..thanks yaar...
wlcm bro
Deepak ji ,
Excellent your teaching method in TH-cam
Easily to understand .
I am extremely glad for your tutorial
Very nice method of explaining & it ensures clarity. Thanks for good efforts towards spreading knowledge to all needy.
Sir ur teaching style is very very good. Ur Every video is under stand able.very helpfull for me.
Thank you so much for your video..❤ aaeise hi video banate raho..🤗
😊😊
Thanx sir ap bhut achha explain krte hain....
your every video is very helpful thank you sir
Very helpful video Deepak thanks...
Very nice video sir bahut jabarjast trick hai sir ji thanku sir
Thank you sir ,this is very usefull video 🙏🙏
Thank you Deepak Ji, Very useful
love you sir... ❤🌻🥰
Marbulous video sir
Thanks for uploading video
Jabardast Deepak sir..really very good
Aap bahut aache samjhte hai sir
Aachi videoo kch nya shikhne ko mila thnx
Deepak bhai the way of yr teaching is very unique n excellent lot of things n formulas have learnt from u , i drsire to know how v can put the specific numbers in a specific text that always indicate with that text ..... thank
Custom number formatting 👍
Veryhelpful sir thank you
sir the video is very useful . . i have learned so many things. i am a teacher. kindly tell me about which type of questions are asked in advance
excel interview
Bhut accha smghaya
Excellent👍
thanks deepak it will help alot
Muje sir cell me 1g,3kg,3ton allow karna he par... Only 1,2,3 digit enter kare to error dikhani hey... To me kya karu.... Please inform me...
Very Useful Video Sir
Sir, You have excellent explaining skills. Your videos are very helpful for my day to day work in office. I have encountered a doubt. The validation cell/column is ignoring the validation when pasted other data. The cell should prevent and say that "the value you entered can not be allowed". Plz. clarify. Regards.
V nyc explanation
Thanks Deepak ji.
thank you so much sir could you please add 1 videos how would be fix the capital letter in the cells of excel.
Nyc sir..👍 Aapki sari video superb h....👏
But mera bhi 1 *questions* h ki Sir jb text & numberic value 1 saath ho.. --> as232mf56df8
Agr aisa format ho to kya formula lagega ?
Plz solve & Send video..🙏
great video sir thanku so much for this
Bahut achcha laga.
Your video very beautiful friend
Thank you very much
Sir,
How alphanumeric like PAN No. can be entered in a cell in this process?
Very good video
Very useful, thanks
th-cam.com/video/fpslxPp3_Cw/w-d-xo.html watch it.. You may get an idea.. How to do it
Super Deepak
Very healthful sir
Great 👌
Many many thanks to u sir
Excellent
Sir how do you work in zooming screen. During screen recording
Dynamic dropdown list without duplicates.Suggest your videos
An excellent video.
Mast he bro...thnx and keep on...
thanks
Sir agar name ke saath koi digit enter karne se bhi true hi dikha raha hai... Wo kaise thik kare...?????
Great tricks........on the line...
Sir can you new file.......
" Condition formatting & consolidate sheet ..........,"
Plz make it..............
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
I really really appreciate with your explanation and very much clarity. Thanks for you effort and knowledge sharing. But, I have a question, In case if user wan't to enter the character like CRC0002001, CRC0002002 etc. Its like your company code, employee code or anything similar.
Can we do this using data validation or we have to use VBA.
Thanks deepak sir
Sir ,welcom,
deta entry ka kaam main jo heading hota hai usko requirment ke hisab se make karna parta ha ya apne se khud heading banana parta hai ek videos main deta entry ke headin ke bare main video banaye kya kya aur kaisa kaisa heading hota hai plzzz explain it
Ok thanks sir
🤗
Please make video on
How to make a monthly report on bills prepares in a month and at the end it show total amount of all bills and if there is any correction in any bill it will automatically update in report.
okay .... as soon as possible
Sir I want to know if data is in row position some data in below row but 1st 4 col blank & same in remaining row as it's and I want a data in another sheet except 1st row data wants & come out from 3rd row col no.6 ka data out come in another sheet lookup value in 1st row like 1st row and 1st col.
Hello sir i liked your all tutorials. And i have one question to ask that is i have 10 alphanumeric values in first column and on the second column i want to enter some values but there should be a condition that is.It takes or enter only between that 10 alphanumeric values which are given in a first column. And Can't take duplicate values or can't take double enter of any values which are present in a first column.
Assalam o alikum sir thanks for you nice information plz btaye k number or alphabet ka aik sath validation rule kaise bnayae
Plz video poora dekhiye dhyan se 👍
Nhi sir mean k hm aik aisa validation rule bnana chahey jis mai alphabets or numbers k ilawa or kuch agr hm apni file mai enter krna chahey tu wo excel hmey error dai dai
Sir man lijiye ki mob. No. Do types ke h, ek 7 digit ka or ek 10 digit ka toh aise condition me kaise is formula ko update krenge.. mtlb mob. No 7 digit ka accept kre ya fir 10 digit ka.. dono ke bich ka bhi digit accept na ho? I tried by using "OR" in the place of "AND" but it didn't work
(?) hi bro , and len furmala is working only if we select one cell iit is not working on column of 12 cell, but if wee drag thatt one cell than it is working , can you please tell me how this and len formula working on multiple selection at one time . because i have tried this on 1 cell than its working , but when i gave it range of (a2:a12) than this formula is not working . please reply me.
nice video sir
Kya kisi work sheet ya kisi cell ya kisi row ya collom me esa kuch kiya ja sakta he ki usme kisi bhi case me likha jaye vo automatically propper ya upper ya lower case me convert ho jaye ??
Ysss
Pls share
Dear brother,
Please how to enter mobile no start fro 0 in data validation.
Please show public formulas
sir countif,len,ISNUMBER formula ek saath kaam kaise krte hai ,jaise phone no. 10 hi ho number me ho, dublicate bhi na ho
Sir esme font pr bhi data validation lga sakte hai kya?
very usefull
Hi bro
How r u, hope you are well.
I have a doubt. How to set automatically sms or message to WhatsApp in excel if due date completed?
Kindly advise to me.. Thanks
sir mujhe ye bhi apko batana tha ki is video ke neeche jo custom data validation & number ki jagah numbes kiha hai.
Deepak ji ifsc code me 11 text+digit milakar hote he to hum kese 4 text aur 7 digit set kr skte he...Plz btaye
Dear Deepak,
Main jab duplicate ka farmula lagata hon tou lagta naihy =countif( )=1Please Detail say bitainy.Ejaz hussain virk.
Sir excel me custom data validation by pan card number kaise enter karein
very good.
Sir, आप gst invoice का video upload करेंगे. ओ भी उसका data और sr no और के हिसाबसे backup के साथ
prabhakar pawar
Aap isey 2way me Kar sakte hai
1st aap sirf Data to Table me badal de
2offest see
Conditional formating main kase ak symbol use karte hai, please ak video bano do, plz sir ji
G
Please share a vedio link in for drop down if select boy or girl it shows male and female in just other cell for
Watch it th-cam.com/video/Ig245IO7lPs/w-d-xo.html
Sir, would u plz let me know how can we use data validation for blood group to prevent entering of invalid blood groups
Make dropdown list of bloodgroups in range of cells...
Just write blood groups in a column.. Copy them.. Go to data validation.. Choose list.. And in the source box.. Paste them.. All done.. Now in selected range.. You can only select bloodgroups from dropdown
Sir lekin meye istext function use Kar raha hu aur cell meye "a123abc" lekh rakha hu Tb accept Kar raha hai ..tab Koi error msg show Nahi Kar raha.. Sirf only alphabet ke leye kya Karna hoga... Please help...
A12fg4. Agar alphabet's ke sath kuch bhi mix hota hai.. koi bhi number ya symbol.. to wo text hi mana jata hai
Good job
would you be able to share the custom validation to enter characters eg: 123L (Three number and one Alphabet)
Nice Bro
Sir please tell me permanently set word formula in excel all work book..
Sir ek error he
Jab ham omprakash name type karte he to
Jab ham o ke sthan pe zero (0) type kar dete he to bhi results true aata he
Nice video
Dear Mr. Deepak,
How can start mobile no from 0 in data validation. Please send formula.
Thanks and Regards
great sir
THAN'S
Sir ma aik per different sheets sa data dropdown list bnana chahta hu kindly guide me
th-cam.com/video/-IDqfwby5MM/w-d-xo.html
Sir koi Negative Sign Number and brackets remove excel sheet ka video banaye.
okay ji... publish as soon as possible
सर एक ऐसा वीडियो चाइए जिसमे मैक्रो
रिकॉर्ड करके डाटा 2एनडी शीट पर जाए, लिकिन वह एंट्री तभी हो जब सभी सेल फिल है अन्यथा एंट्री ना हो। सर प्लीज बना दीजिए।🙏🙏🙏
Sir muje sheet me IFSC code lagana hai
To kuch digit text me chahiye aur baki number me chahiye
+Vasant Bhanushali ok... From home tab.. Go to number format.. Select cell range and choose text from number format option...
Deepak EduWorld
Conditional formatting lagana hai
Jaise ki ristrict data and no karna hai ek hi cell me
Sir ji,
Namste
Sir ji meri ek word office 10 ki file hai jis pe password lga hai mai usk a password bhul gya hu uska password kaise remove hoga aur data bhi safe rakhana hai
Please guide sir ji
Its hacking dear.. If i publish such type of video. That will be illegal
@@DeepakEduWorld
Sir ji
usme bahut most data hai aur
Jaruri hai
You can teach us ethical hacking, it's not illegal
Sir
Agar yes or no ke liye data validation lagana hoto kya formula hoga?????
Ok g u will publish video on this topic as soon as possible
Please teach us npv n regression in Excel
Bro ek questions he..Agar name wale column me text or number milake likhajae to lejarahahe.... thoda batanye only text kese lega...plz
Okay... i 'll publish another video as soon as possible
Deepak EduWorld OK.thnx fr ur response..
bijay kumar Kar
Bhai tumhara sawaal Kya hai ?
Jo tum pooch rahe ho Wo already isne Bata Diya hai
Ab sawaal dubara see dekho or video ko bhi
mera v same question hai please is per video bnai chahiye.
K g Thora jaldi because mujhe iski answer ki need hai
Ky text or number ka validation dono ek sath use kr skta h example pan card number 10 digit ka hota h 6 text or 4 number to muje ek call ye validation lgna h ki mera text na to 6 se jada ya km or number 4 se jada ya km na ho
Its prevents the user from entering invalid values if they enter invalid values. But its not preventing from pasting invalid values. please guide me.
Sir ek query hai ki text main sirf text aaye or kuch nahi example Amit likha aaya par agar Amit4 aaye to ye accept karta hai par nahi karna chaiye
Hello Sir,
You will be fine, I hope so.
Will you give me a formula for data validation
Text only i.e John
Not acceptable
John1
Jo1hn
J9hn etc
Thanks