🔥 Fully Advanced Custom DATA VALIDATION in Excel (6 examples) - Data Validation in Excel in Hindi

[@tapasyajha7183]

Seriously u cleared all the doubts with advanced data validation function, great thanks to you sir really ek ek concept aapne ache se samjhaya ❤

[@narottammanihal8463]

अति सुन्दर दीपक जी, बहुत ही बढ़िया तरीके से समझाया आपने । Very good

[@supriyammondal8294]

Bahut hi badhiya hai sir

[@nitinsingh00]

आग लगा दिए हो सर पूरे इंटरनेट पर

[@manojchakerwarti]

Very Good Explanation Deepak Ji, keep it up

[@vishwanathranamale606]

har din mai apke naye videos ki rah dekhata hu

[@rajneeshendla6182]

🚩 Jai Hind Vande Maatharam Guruji 🙏

[@BruceLee-lx6zh]

Gajab... Maza aa gaya

[@surajsunar4119]

Deepak ji you really explain very well and very clearly. Your have really helped me a lot to improve my excel....

[@sureshnagwan7805]

Bahut achha batate ho aap 👍

[@ujjwalchakraborty8840]

Your every video is informative.. thank you so much for sharing such aweasome videos with us..thanks a lot ❤️❤️

[@vikashmourya8964]

Genius sir love your work

[@avdheshanand8859]

Easily explained sir. Please make a video ... How to make a report in Excel ???

[@vishwanathranamale606]

i have used your formula in share market screener thank sir for filter stock

[@KuldeepSingh-nq1vi]

Best Video ever👍👍👍👍

[@ajayakunayak1700]

The Best Teacher ❤️

[@pa2happiness13]

Super ♥️👌

[@rajoriaavinash]

Thank you sir..

[@sanjayparihar641]

Your owsam Sir salute to you ,🇮🇳🇮🇳🇮🇳🇮🇳

[@rajeshupadhyaya127]

Nice topics .Keep on educating excel to people. Your work is excellent.

[@kawmalmustafa1537]

Thanks you so much Very interesting video

[@RahulKumar-ly6ly]

Thanks a lot sir ji

[@tejpalsain1507]

Super duper vedio sir. Thanks

[@user-A.K.Nayak_957]

Valuable information Nice video

[@arya_ankit94]

Very Nice ... sirf Email wala kuch thik nhi laga.. Rest are Very well explained.

[@pushpadas7854]

Sir datavalidation Mujhe Jo problem ho rho thi ab workout clear hogyee..But fir copy/peste m problem hoti ...Kya Mujhe apne laptop m koi setting krni hogi .. Really is tire aapki en Excel lreaning videos se m bahut inspired hoti. Jo Mujhe Meri job m kafi h help krta h..

[@Kartiksharma006]

Plz computer begainer course per video lao I get a computer but I don't know how to use it

[@tongthokworld5466]

Bahut kamal ka video hei

[@sameenarafiq1339]

Great Job

[@akashpradhan8021]

sir..please make video about form controls & Active x controls

[@rojatalebi1115]

Hi, thanks for your interesting lesson, if we want our phone number start with a specific number like 9, what should use?

[@myknowledge4u]

Hello sir ye sab formulas aap kaha se seekhte ho. Bhut achha information diya hai aapne Aur app bahut aacha padhate ho Ham aapki har video dekhte hai.

[@user-veera]

Sir app ki video bhut helpful hoti hai. Sir Kiya ek hi coloum main foot or inch type Kar sakte hai 12'6"x15'8"=?or answer Ka formula Kiya hoga sir reply jaldi dena

[@vishwanathranamale606]

your videos are very helpfull but i have one query data validation for hindi or marathi language list

[@rajkumarthakur1334]

Deepak ji aap kya explain karte ho 👌👌👌👌 You are the best I must say👏👏👏👏 But deepak ji maine 1 question aapse kitna baar pucha plz reply kardo?? Ik bar fir se puch leta hoon Question:- Agar humein ms word mein text ko fix karna ho toh wo kaise karen so that uske upar niche hum kuch bhi likhe bas woh text hile nhi fix rahe plz bta dijiye??

[@visheshgiri1354]

Sir Visual Basic pr bhi video banaaiye

[@user-Durga.diagnostic]

Sir pathological reporting software in excel

[@surajitsarkar8352]

You really teach everything very well sir. I have a problem. If you solve this I would be very happy. How data from a column of a sheet automatically enter to another column of another sheet but 5 rows after each entry.

[@ujjwalchakraborty8840]

In the sheet where you want to put the data, put "=" in a cell and go to the another sheet in your source data and select the cell then enter

[@pallabdas232514]

Hi dipak ji..main aap ka ek subscriber bol raha hun...Suppose maan lijiye mera ek excel form hain aur macro ke jariye data ko main ne dusra sheet main transfer kar raha hun...uss samay pe yeh validation kaise kam karega...??? Ek vdo banaiye issi topic pe

[@KhmerLearningSpreadsheet]

Hello sir...! You're can doing an transfer data from 3 sheet to 1 sheet? I want to know it's.

[@modellingcouplesong474]

Superb sir

[@sagarkale4031]

Sir ms outlook, ms visio, ms project videos banayi ab... 🙏

[@GajananFunde]

Can we have data validation rule for the condition i.e. say if A2 is selected "Yes", then show dropdown list in B2, otherwise reject the entry?

[@nehalsingh4436]

Sir ms access pe v video banaye plzzz.

[@sahiljatt7925]

Plz upload data validation full coursee

[@firdousahmad194]

First'

[@criccomparers1487]

Deepak Sir...two problems, first is normal:-in last ,PAN includes first 5 alpabets, then 4 numbers and last alpabet, but thats not a big issue as so far this video is concerned, as you have explained well, how to arrange Big problem is that, first 5 digits can be any alpabet not necessarily to be "ABCD" and last digit can also be any digit, so custom validation should check that first 5 digits should be alpabet, then next 4 numeric and last should be alphabet and lenght should be 10 But this custom will only check that first four digit must be ABCD

[@criccomparers1487]

But I must say, you have taught those things, which no teacher , no google could have taught us.....I am your die-hard fan.....A big salute in so much simple language, and in so much detail, and your way of explaining....esp. you use a formula, then increase it, then increase it and then use that somewhere else..... marvelous.....amazing , out of the world

[@najishumar6964]

For that u can simply not use tha equal formula i.e =ABCD & =A. U can try may be u can get ur answer, if I'm right than thank me later 😜😜😜

[@najishumar6964]

Btw u r right... Sir taught very well... Clearly and easy to learn and main thing is easy to remember 🥰🥰

[@Sanu_0]

Sir ap kabhi html video end karenge

[@hamzanazeer3818]

first view first like 🥺

[@pamelchowdhury]

Good

[@iamsainipawan]

Sir please make pawer query basic to advance tuteriol video

[@amitrana8147]

Bhut tricky hain

[@amitrana8147]

Sir apka koi paid couse hain kya?

[@Arshi718]

How to fix some predetermined data like dob, id, mobile no. etc with personal id and deemed that info. Like banks put their clients economic sector, geo area code, investor name according to customer id. But bcoz of drop down list they make mistakes to select correct info in each quarter. All I want to do is they may have a visual for those predetermined data, by selecting individual id but can’t able to change them

[@tapa671]

Nice

[@rajadey1552]

Sir main n ek cell m vlookup 4mula lagaya condition k sath. Ab me chahta hu jaha m vlookup lagaya waha ki condition fullfill ho to formula still rah jaye. Or condition exactly match nhi hoto me ek validation k through us cell ko specific message dena chahta hu.... Matlab sir formula and datavaildation ek sath kaam kare... Kya aisa ho sakta hai. Agar ap k paas koye vdo ho to plz link share kijiye na. Plz🙏🙏🙏🙏🙏🙏🙏

[@smmh.]

Excel ka full tutorial ka video upload kijiye Sir jee

[@najishumar6964]

Sir ji email wale formule me * or ? Ka use kyu kiyee... ??? Can u please explain if possible??

[@sandipnaskar2568]

Just osm sir.

[@englishlink6546]

Last one does not seem to be correct.. My pan starts with DZGPP it will anyway present it wrong though it's absolutely correct.

[@arya_ankit94]

Genuin Question raised by u..... I found the solution, plz go through it.. =AND(ISTEXT(LEFT(B12,4)),ISNUMBER(VALUE(MID(B12,5,5))),ISTEXT(RIGHT(B12,1)),LEN(B12)=10)

[@sushiljoshi9211]

Deepak.. I want to convert text to upper case as I type and press enter it in excel in any case with out help od VBA , is it possible ??? I am searching it from long time... Please Help.

[@DeepakEduWorld]

Select data range.. and apply any uppercase font style.. 👍👍 all done.. without formula..

[@grootgaming04]

Sir as you have mentioned that four characters u have chosen is "ABCD" it is not necessary every time. Any 4 characters came any time then your formula will wrong and i have tested in my excel. Then how could you mention the four characters as "ABCD".

[@arya_ankit94]

Genuin Question raised by u..... I found the solution, plz go through it.. =AND(ISTEXT(LEFT(B12,4)),ISNUMBER(VALUE(MID(B12,5,5))),ISTEXT(RIGHT(B12,1)),LEN(B12)=10)

[@nahidsaiyed8147]

Superb

[@harighotad]

Sir Great Video but initial letters of PAN are not always ABCD. It may be any combination of alphabet. So what in that case??

[@ashokkumar-df7jo]

Use and formula like equal to and(istext(cell of data), len(cell of data) =4

[@narottammanihal8463]

Use formula ISTEXT

[@GurdeepSingh-jy3cz]

@@ashokkumar-df7jo right

[@ashokkumar-df7jo]

Right ji it works

[@Noumanjavedshamsi]

Nice video

[@govindgupta9544]

👍👍

[@satishcomputersportsedu.9440]

Nice sir

[@naturallyoccurring7135]

सब बढ़िया है लेकिन लास्ट वाला लॉजिकल नहीं है क्योंकि पेन नंबर के टेक्स्ट करैक्टर अलग-अलग होते हैं

[@arya_ankit94]

Genuin Question raised by u..... I found the solution, plz go through it.. =AND(ISTEXT(LEFT(B12,4)),ISNUMBER(VALUE(MID(B12,5,5))),ISTEXT(RIGHT(B12,1)),LEN(B12)=10)

[@puneetjain7934]

Hello Sir, Data validation limited table mein kaam karta hai. Agar aur data add karna ho fir kaise data validation kaam karega. Please tell.

[@sanjeev6100]

Deepak ji one invoice multiple payment or products entry kaise karate plz video banavo and invoice no diye to same product makes list karunga

[@AshishSharma-gs5tu]

👌👌

[@vishwanathranamale606]

apka filter vlookup sort in google sheet sab apki krupa hai sir

[@usmankhan2920]

Sir hamen aisi validation lagani ha k hum beech ma koi khali cell chorh k entry na kr saken sequence se entry karen to kese hoga ye

[@pankajknowledgeworld]

17-11-2021. ========= 1. Sir मैं एक फॉर्मूला ये ढूंढ रहा हू की जिस सेल में नाम लिखते हैं या दूसरी character text लिखते हैं तो उस सेल में अगर lower upper कुछ भी mix लिखा हो. उस सेल में अपने आप proper case मैं वो लिखा हुआ हो जाए.. ज्यादातर वीडियो जो देखी वो एक सेल में लिखते हैं दूसरे सेल में फॉर्मूला apply करते हैं. जब की मैं same सेल में automatic apply कैसे होता है वो बता दो. Without vba.

[@karanjot191]

In appointment data, when we apply data validation using this formula [ =WEEKDAY(A5,2)

[@ubaidillahmuhammad20]

loved it

[@rajibranjan8619]

Good evening sirji. sirji aisa h ki excel me hindi me type karte h to formula bar me english dikhta h zab ki ham ye chahte h ki formula bar me v hindi dikhe. ye problem kaise solve hoga. ye bataye. thanku.

[@Satyendra2022]

𝗧𝗵𝗮𝗻𝗸❤🌹🙏 𝘆𝗼𝘂💯🤜😆

[@Official_Suraz]

Excel main time format ko doosee cells main copy kaise karte hai maine try kiya tha nahi huwa hai....

[@divyabharti6704]

Sir upper case m digit bhi accept kr rha h but hame data validation m only upper case m hi leni h digit nhi honi chahiye iske liye kuch bataiye sir kya kr sakte h

[@hamzanazeer3818]

first

[@sachinsambokar2266]

Hi I want to seperate data from one cell all data is in one cell only as shown below all data entered like alt+enter in a cell and I want to separate that 0.15 0.11 0.55 1.50

[@grootgaming04]

And sir u have also taken the PAN no. Wrong in PAN no. There always comes 1st five letters of alphabet and 4 digits no. And at last 1 Letter of alphabet.

[@sambhu2374]

👍

[@gautamsanyal9540]

In case of any other PAN Number format, i.e. if letters are different, this formula does not work. So plz derive an unique formula that can be applicable universally.

[@arya_ankit94]

Genuin Question raised by u..... I found the solution, plz go through it.. =AND(ISTEXT(LEFT(B12,4)),ISNUMBER(VALUE(MID(B12,5,5))),ISTEXT(RIGHT(B12,1)),LEN(B12)=10)

[@vindus4215]

Sir, if i copy data (which do not follow my custom validation rules) from another sheet & paste it in a new sheet where I already added validation rules; then can that data be entered or be rejected ??

[@rajeshupadhyaya127]

If I m not wrong,Validation formula works for same sheet.

[@supriyammondal8294]

Excel me ek problem aa gai hai Do column hai, a aur b, alag alag dynamic value wale Ab mujhe dusre sheet par ye dono column ek hi column me ek ke bad ek copy karwane hai, please koi formula bataye. Mtlb agar "column a" me 10 rows hai aur "column b" me 5 rows hai Toh dusre sheet par "column a" ke 10 rows khatam hone ke baad "column b" ke 5 rows, 11th row se suru honge.

[@shiwendrakumar247]

But PAN me to text different-different hote hai to kaise hoga

[@arya_ankit94]

Genuin Question raised by u..... I found the solution, plz go through it.. =AND(ISTEXT(LEFT(B12,4)),ISNUMBER(VALUE(MID(B12,5,5))),ISTEXT(RIGHT(B12,1)),LEN(B12)=10)

[@pankajknowledgeworld]

Pan number main jo abcd लिखा उसकी जगह कुछ और igdk हुआ या कोई character value hui toh kaise करे

[@68415786]

❤️❤️❤️❤️🙏🙏🙏

[@AbhishekKumar-ik4hg]

❤❤❤❤

[@vishwanathranamale606]

baki sub mai apse shika hu sir

[@meditationcentre1616]

Sir new laptop me deta validation show nahi ho raha hai

[@shivamkumarsingh6923]

Need Data Validation for Any one Alphabet and 7 numbers Like Example:- P1102345,G1238766

[@MdJavedAlam-ni8tc]

Data validation me Jo aap pan number wala formula bataye hai.. Usme 4 Alphabet sabhi ka same to nhi de sakte n har pan number me Alag Alag Alphabet hota hai to kewal ABCD ka Example kyu 4 Alphabet koi bhi. 5 digit no. Koi bhi. Last 1 alphabet koi bhi Yahi hona chahiye n....?????

[@hamzanazeer3818]

😁

[@divyabharti6704]

Please sir help me

[@koushikmandal8311]

❤😊😮😢

[@faheemnizam6041]

🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰

[@cricketgamer9660]

Please sir reply m