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)
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..
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
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??
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
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
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
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
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.
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🙏🙏🙏🙏🙏🙏🙏
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)
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.
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)
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.
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)
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
17-11-2021. ========= 1. Sir मैं एक फॉर्मूला ये ढूंढ रहा हू की जिस सेल में नाम लिखते हैं या दूसरी character text लिखते हैं तो उस सेल में अगर lower upper कुछ भी mix लिखा हो. उस सेल में अपने आप proper case मैं वो लिखा हुआ हो जाए.. ज्यादातर वीडियो जो देखी वो एक सेल में लिखते हैं दूसरे सेल में फॉर्मूला apply करते हैं. जब की मैं same सेल में automatic apply कैसे होता है वो बता दो. Without vba.
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.
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 ??
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.
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
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....?????
Seriously u cleared all the doubts with advanced data validation function, great thanks to you sir really ek ek concept aapne ache se samjhaya ❤
Bahut hi badhiya hai sir
आग लगा दिए हो सर पूरे इंटरनेट पर
Very Good Explanation Deepak Ji, keep it up
अति सुन्दर दीपक जी,
बहुत ही बढ़िया तरीके से समझाया आपने । Very good
har din mai apke naye videos ki rah dekhata hu
Super ♥️👌
Plz computer begainer course per video lao I get a computer but I don't know how to use it
Gajab... Maza aa gaya
Thank you sir..
Best Video ever👍👍👍👍
Bahut achha batate ho aap 👍
Easily explained sir.
Please make a video ... How to make a report in Excel ???
🚩
Jai Hind
Vande Maatharam
Guruji 🙏
i have used your formula in share market screener thank sir for filter stock
Excellent video Sir
The Best Teacher ❤️
Super duper vedio sir.
Thanks
Thanks a lot sir ji
Genius sir love your work
Deepak ji you really explain very well and very clearly. Your have really helped me a lot to improve my excel....
Your every video is informative.. thank you so much for sharing such aweasome videos with us..thanks a lot ❤️❤️
Nice topics .Keep on educating excel to people. Your work is excellent.
Very Nice ... sirf Email wala kuch thik nhi laga.. Rest are Very well explained.
Your owsam Sir salute to you ,🇮🇳🇮🇳🇮🇳🇮🇳
Great Job
Thanks you so much
Very interesting video
Valuable information
Nice video
सब बढ़िया है लेकिन लास्ट वाला लॉजिकल नहीं है क्योंकि पेन नंबर के टेक्स्ट करैक्टर अलग-अलग होते हैं
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)
Bahut kamal ka video hei
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..
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
first view first like 🥺
Sir apka koi paid couse hain kya?
Sir Visual Basic pr bhi video banaaiye
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??
Sir ms outlook, ms visio, ms project videos banayi ab... 🙏
First'
Sir ms access pe v video banaye plzzz.
Sir pathological reporting software in excel
Plz upload data validation full coursee
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
Superb sir
Sir ap kabhi html video end karenge
sir..please make video about form controls & Active x controls
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.
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
Sir please make pawer query basic to advance tuteriol video
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
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
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 😜😜😜
Btw u r right... Sir taught very well... Clearly and easy to learn and main thing is easy to remember 🥰🥰
Good
your videos are very helpfull but i have one query data validation for hindi or marathi language list
Nice
Hi, thanks for your interesting lesson, if we want our phone number start with a specific number like 9, what should use?
Just osm sir.
Superb
Sir Great Video but initial letters of PAN are not always ABCD. It may be any combination of alphabet. So what in that case??
Use and formula like equal to and(istext(cell of data), len(cell of data) =4
Use formula ISTEXT
@@ashokkumar-df7jo right
Right ji it works
Bhut tricky hain
👍👍
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.
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
Nice video
Excel ka full tutorial ka video upload kijiye Sir jee
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?
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🙏🙏🙏🙏🙏🙏🙏
𝗧𝗵𝗮𝗻𝗸❤🌹🙏 𝘆𝗼𝘂💯🤜😆
Hello sir...! You're can doing an transfer data from 3 sheet to 1 sheet? I want to know it's.
Nice sir
👌👌
loved it
Last one does not seem to be correct.. My pan starts with DZGPP it will anyway present it wrong though it's absolutely correct.
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)
first
Sir ji email wale formule me * or ? Ka use kyu kiyee... ??? Can u please explain if possible??
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.
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)
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.
Select data range.. and apply any uppercase font style.. 👍👍 all done.. without formula..
apka filter vlookup sort in google sheet sab apki krupa hai sir
Hello Sir, Data validation limited table mein kaam karta hai. Agar aur data add karna ho fir kaise data validation kaam karega. Please tell.
❤❤❤❤
But PAN me to text different-different hote hai to kaise hoga
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)
👍
❤️❤️❤️❤️🙏🙏🙏
Deepak ji one invoice multiple payment or products entry kaise karate plz video banavo and invoice no diye to same product makes list karunga
Excel main time format ko doosee cells main copy kaise karte hai maine try kiya tha nahi huwa hai....
In appointment data, when we apply data validation using this formula [ =WEEKDAY(A5,2)
Sir new laptop me deta validation show nahi ho raha hai
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
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
17-11-2021.
=========
1. Sir मैं एक फॉर्मूला ये ढूंढ रहा हू की जिस सेल में नाम लिखते हैं या दूसरी character text लिखते हैं तो उस सेल में अगर lower upper कुछ भी mix लिखा हो. उस सेल में अपने आप proper case मैं वो लिखा हुआ हो जाए..
ज्यादातर वीडियो जो देखी वो एक सेल में लिखते हैं दूसरे सेल में फॉर्मूला apply करते हैं. जब की मैं same सेल में automatic apply कैसे होता है वो बता दो. Without vba.
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.
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 ??
If I m not wrong,Validation formula works for same sheet.
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.
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
baki sub mai apse shika hu sir
Pan number main jo abcd लिखा उसकी जगह कुछ और igdk हुआ या कोई character value hui toh kaise करे
Need Data Validation for
Any one Alphabet and 7 numbers
Like Example:-
P1102345,G1238766
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....?????
❤😊😮😢
😁
Please sir help me
Sir yeah excel m kaise bana gya 👉👉👉th-cam.com/video/00HVIIvm_xg/w-d-xo.html
Please sir reply m
🇵🇰🇵🇰🇵🇰🇵🇰🇵🇰