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..🙏
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
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.
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
(?) 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.
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
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 ??
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.
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.
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.
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
Great tricks........on the line... Sir can you new file....... " Condition formatting & consolidate sheet ..........," Plz make it.............. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
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
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
Good afternoon sir, Sir,one column mein 1cell ka number 2,3,4cell mein ctrl +D press karke paste Kar sakte hain..OK..Lekin 5cell ke number ko bhi 6,7,8,9,10cell ko bhi ctrl +D press karke paste Kar sakte hain...but 6000-7000 data rahega toh Har bar ctrl +D press ya F4 dabana padega......? Koi formula suggest kariye.
sir mujhe yeh jan na hai ki if i enter same phone no or same aadhar no in cell to allow nahi kare. and vo bhi 10 digit ka to kaise setting and error alert may mesage likinge,please guide asap
![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
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
Thanks sir
Aap hr option Bahut achhi tarah se clear krte hai
Bhai tu bhot acche se smjhata h..thanks yaar...
wlcm bro
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
Deepak ji ,
Excellent your teaching method in UA-cam
Easily to understand .
I am extremely glad for your tutorial
Thanx sir ap bhut achha explain krte hain....
Very nice video sir bahut jabarjast trick hai sir ji thanku sir
Aap bahut aache samjhte hai sir
Aachi videoo kch nya shikhne ko mila thnx
Sir ur teaching style is very very good. Ur Every video is under stand able.very helpfull for me.
Very nice method of explaining & it ensures clarity. Thanks for good efforts towards spreading knowledge to all needy.
Thank you sir ,this is very usefull video 🙏🙏
Thank you Deepak Ji, Very useful
Bhut accha smghaya
Thank you so much for your video..❤ aaeise hi video banate raho..🤗
😊😊
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 👍
Very helpful video Deepak thanks...
Marbulous video sir
Thanks for uploading video
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
Thanks Deepak ji.
Veryhelpful sir thank you
thanks deepak it will help alot
love you sir... ❤🌻🥰
Nice tutorial video...... Thanks
😊😊
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.
i have the same question
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
Bahut achcha laga.
Thx sir very very nice video.
😊
Jabardast Deepak sir..really very good
Thank you very much
V nyc explanation
Your video very beautiful friend
Sir how do you work in zooming screen. During screen recording
Excellent👍
thank you so much sir could you please add 1 videos how would be fix the capital letter in the cells of excel.
Very good video
Many many thanks to u sir
Sir,
How alphanumeric like PAN No. can be entered in a cell in this process?
Very healthful sir
An excellent video.
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..🙏
Thanks deepak sir
Excellent
Dynamic dropdown list without duplicates.Suggest your videos
Sir agar name ke saath koi digit enter karne se bhi true hi dikha raha hai... Wo kaise thik kare...?????
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
Sir esme font pr bhi data validation lga sakte hai kya?
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.
Sir excel me custom data validation by pan card number kaise enter karein
Super Deepak
Mast he bro...thnx and keep on...
thanks
nice video sir
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
Great 👌
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
sir mujhe ye bhi apko batana tha ki is video ke neeche jo custom data validation & number ki jagah numbes kiha hai.
(?) 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.
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
🤗
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
sir countif,len,ISNUMBER formula ek saath kaam kaise krte hai ,jaise phone no. 10 hi ho number me ho, dublicate bhi na ho
Please share same process for google online sheet
very usefull
Conditional formating main kase ak symbol use karte hai, please ak video bano do, plz sir ji
G
Dear brother,
Please how to enter mobile no start fro 0 in data validation.
Please show public formulas
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.
Dear Deepak,
Main jab duplicate ka farmula lagata hon tou lagta naihy =countif( )=1Please Detail say bitainy.Ejaz hussain virk.
very good.
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
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 please tell me permanently set word formula in excel all work book..
Good job
Please teach us npv n regression in Excel
thanks sir
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 ji yadi mujhe culum me vehicle no likhna he to koi formula he kya
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 ua-cam.com/video/Ig245IO7lPs/v-deo.html
THAN'S
Sir ma aik per different sheets sa data dropdown list bnana chahta hu kindly guide me
ua-cam.com/video/-IDqfwby5MM/v-deo.html
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
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
Dear Mr. Deepak,
How can start mobile no from 0 in data validation. Please send formula.
Thanks and Regards
Great tricks........on the line...
Sir can you new file.......
" Condition formatting & consolidate sheet ..........,"
Plz make it..............
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
would you be able to share the custom validation to enter characters eg: 123L (Three number and one Alphabet)
pan card ka no. hai to kya formula lagayenge rply jaroor kriyega
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
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
Sir how to use for what If Analysis in Excel please u tell me and Show me video
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
Good afternoon sir,
Sir,one column mein 1cell ka number 2,3,4cell mein ctrl +D press karke paste Kar sakte hain..OK..Lekin 5cell ke number ko bhi 6,7,8,9,10cell ko bhi ctrl +D press karke paste Kar sakte hain...but 6000-7000 data rahega toh Har bar ctrl +D press ya F4 dabana padega......? Koi formula suggest kariye.
power point par video banaiye
Please help agar nehi hoga to Google sheet ke upor ek vedio banaiye
sir mujhe yeh jan na hai ki if i enter same phone no or same aadhar no in cell to allow nahi kare. and vo bhi 10 digit ka to kaise setting and error alert may mesage likinge,please guide asap
How to calculate in cell 23+5 and sum all. Please give me link
sir data validation ka formula kis cell mai use kiya gaya hai ye kaise pata lagana hai? aapne bataya tha but mai bhul gaya
Sir koi Negative Sign Number and brackets remove excel sheet ka video banaye.
okay ji... publish as soon as possible