Sir apke bhttt s videoo dekhe sb bhtt aache h hr video m kch na kch na shikhne ko milta h m apne stdnts ko apka videoo dekh dekh k new new cheeje shikha rhe jissee mujhe bhi bhtt kch shikhne ko mil rha
Thank you Sir, Your videos of MS Office Excel are very clear, It will help us in making of our career, Dear Sir, I will wait for detail tutorial about (Connection of multiples works sheets into one sheet, (2) Combination of multiple works sheets into one sheet, (3) Linking of multiple work sheets into one sheet and (4) consolidate of multiple work sheets into one sheet. Sir these tutorials are very mandatory for every accountant.
Deepak Sir, I have create userform and the date save automatically to another sheet and by vlookup I edit the entry and I want it save in same sheet where I am saving the data by update the same and not create duplicate entry.Please Sir Guide
Dear, Deepak data validation duplicate value pr ap nay kafi achi video publish ki uske liye thanks but us condition me agr Cell se data ko copy paste ya drag down karte hay tu same values ko cell restrict nahe kar rahe or same data other cell pe ajata hay kiya koi esa process hay jo use bhe control kiya jaye data validation kay through..
Dear Deepak you shared very useful videos . please make about all pivots table related video and give all links in same video .I am waiting for your kind response .
Sir ,Nice video, i am seeing your videos, sir i have doubt in datavalidation how to write formula for greater than less than for school fees. I have different school fee amount if total school fee is greater than received amount it show error message. for ex if 10th class fee is 10000 if received amount equal 10000 ok if its greater than 10000 it show errror message.
Ctrl D krne par aur copy krne par ye validation kam nhi krta only value enter krne par hi alert box aata h, but me chahta hu ki duplicate value ho hi na range me uske liye formula batao
SIR AAP KE VIDEO SE MAINE BAHUT KUCH SEEKHAA MAI EXCEL PR PHARMACEUTICAL OUR HERBAL KE MFG. KE USE JANA CAHTAA HOON KYO KI MAI EK HERBAL COMPANY CHALATA HOON
Thank you for this video. Super video. Question- I have data in 6 column and data are same in all columns (data like- B200089NT67) when I select data range and apply condition formatting duplicate then all duplicate highlights but when go to duplicate remove option and apply then I find error "No duplicate find value" so how to solve it. I had also checked all data extra space using Trim and also checked cell value is correct. Example- Column1 Colum2 Column 3 DR000257DT TR56884QR ASG489901 DR000257DT
Dear Deepak Ji Please share how to use vlookup for same item code but different rate for different costumer use in bill formate. This will be very useful in macking bills
Nice video but i have one issue If we copy a number which is already in the cell range from any other sheet it is not showing warning.how we avoid this issue
I trying to transfer data from one password protected sheet to other protected sheets by using macros. But since it is being password protected data from one sheet not getting transfer and error message appears. Sheets have been protected to avoid delenerate changes by multiple users. Pls advice.
This formula is work only for row wise but i want to know formula which is work row and column both at a time (like- A1:A10 & A1:J1), Thanks is advanced.
Pranam deepak sir. Main aap ka bahut bara fan hu aur ek student bhi hu. Aap ka yeh formula maine apply kiya hai aur duplicate entry 2nd time entry nahi ho rahi hai lakin sir ek problem bhi hai please help kijiye. Agar koi bhi data main copy paste kar raha hu to fir table me data accept ho raha hai. Agar type karu to fir problem nahi hai. Agar copy paste karu koi bhi data fir jitni bar chahu kar sakta hu. Copy paste ko kaise roka jai. Please help me. Thank u sir. Pranam
Sir isame massage nahi atometic delete ho jaye. Aisa kuch ho sakta hai kaya. Me chahta hu ki ak sheet se dusri sheet pAr advance fillter se data aa jaye or automatic usame se dupalicate delete ho jaye. Please sir bataye
@ deepak sir mai 1k company mai working hyun mere under mai 72 empoly hai,and we 2015 se kaam kar rahe hai ,mere pass unka pura sale data hai 5 saal kaa with empoly id to mujhe unko ye data each candidate ko dena hai har 5 din ke baad jaise hi unka data khatam ho jata hai fir jab mai unko data send karu to mujhe kaise pata chalega ki maine unko kaha tak data aur jab tak kaa data diya hai... please shoot video on this and please please please revert sir..
This doesn't work when there is a slash in the entry. I am maintaining a Invoice database. When I enter the Invoice No. MH/17-18/001 twice, it should give me the warning that this is duplicate entry. Is that possible ?
=if(or(search(M2,C6),search(M2,D6)),"Yes","No") isme error aata hai kyuki D6 ka text M2 k sath match nahi hota to kya is error ka solution ho sakta hai , pl send this type example
Sir, good evening. Sir agr Mai name column me jaldi jaldi me yami6n2 type kr deti hu toh bhi data validation isko text Mann KR accept kr lega. Error nhi dega. Aisi situation me is trike ki mistake na ho data entry me toh kaun sa formula pick kru. Mujhe Kya condition apply krni chahiye
Sir next que. Mera yeh hai ki Agr Mai sales order department me work krti hu Or ek customer ne mujhe ek din me 17 order diye hai, tab bhi data entry krte time uska naam baar baar repeat hoga aisi situation me duplicate value wali agr condition mne apply ki hai toh woh uska naam lega hi nhi toh Mai Kya kru Mai yeh bhi chahti hu Ki agr ek din me ek customer service alg alg order mile yeh bhi entry Mai kru or + agr koi duplicate entry ho rhi hai woh bhi na ho it means agr ek hi customer ke do order ek saath chhda diye hai toh woh na le
![Data Validation In Excel [ Hindi ] - Using Data Validation on Date, Time & Text Length](http://i.ytimg.com/vi/VjVpMVO8Jq0/mqdefault.jpg)
![Data Validation In Excel [ Hindi ] - Using Data Validation on Date, Time & Text Length](/img/tr.png)
दीपक.. आप सचमुच दीपक हो..हमेशा दूसरों को रौशनी और राह दिखाने वाले।।
Sir apke bhttt s videoo dekhe sb bhtt aache h hr video m kch na kch na shikhne ko milta h m apne stdnts ko apka videoo dekh dekh k new new cheeje shikha rhe jissee mujhe bhi bhtt kch shikhne ko mil rha
बहुत ही धीरे धीरे अच्छे से स्टेप बाई स्टेप बताते हो❤
Thank You Deepak Sir, Very Nice ......
nice video especially entering unique number/text. now the concept is clear.
😊😴
Excellent زبردست
really maze ki hai .... the second method you told just amazing isnumber(b4)....maza aa gya sir ji
Thank you Sir, Your videos of MS Office Excel are very clear, It will help us in making of our career, Dear Sir, I will wait for detail tutorial about (Connection of multiples works sheets into one sheet, (2) Combination of multiple works sheets into one sheet, (3) Linking of multiple work sheets into one sheet and (4) consolidate of multiple work sheets into one sheet. Sir these tutorials are very mandatory for every accountant.
+MuhammadNaseer Essakhan okay i will publish video very soon
thank you sir for your help. one more thing please can you provide excel practise sheets for training.
বহুৎ হেল্প ফুল ভিডিও মুঝে বহোত কাম আয়া আপকা ভিডিও চ্যানেল মিলকার মেবি বহুৎ বহুৎ প্রাকটিস করতি হু আপকা ভিডিও দেখার কম্পিউটার মে❤❤❤❤ থ্যাংক ইউ দীপক স্যার❤❤
I am grateful to you Mr. Deepak.
Ye lo nahi hua.....superb sir !!!!
Thank you sir. It's help me lot
Excellent video short and explained very nicely. New user can also understand directly
Excellent Deepak bhai are you great
Bohat Khoob sir g
Thank you🙏🙏🙏... awesome video
Your video always teaches something new
Very helpful formula sir
Nice video sir very helpful formula
Super Deepak Sir
Deepak Sir All your video is very useful.
😊
Deepak Sir, I have create userform and the date save automatically to another sheet and by vlookup I edit the entry and I want it save in same sheet where I am saving the data by update the same and not create duplicate entry.Please Sir Guide
Ok.. Vba se hoga ye. I think usk alawa koi or tarika sayad nhi.. But i ll try to resolve it.. As soon as possible 👍
@@DeepakEduWorld Thanks Sir.If any tutorial in vba in this sloution please share Sir.Once again Thank u very much Sir.
SIR NICE WORK OR VERY HELPFUL VIDEO HE
Dear,
Deepak data validation duplicate value pr ap nay kafi achi video publish ki uske liye thanks but us condition me agr Cell se data ko copy paste ya drag down karte hay tu same values ko cell restrict nahe kar rahe or same data other cell pe ajata hay kiya koi esa process hay jo use bhe control kiya jaye data validation kay through..
Very nice video
আপকা লোগো কো সানজানা কা পরিভাষা বহত আচ্ছা হে❤❤❤
Very nice
Excellent video sir ,pls make video of What if analysis .
ys... i'll publish video on this topic very soon...
okay... I'll publish video as soon as possible
hey bro you are awesome from Bangladesh
😊
Thanks sir ji
Very very thanks
Dear Deepak you shared very useful videos . please make about all pivots table related video and give all links in same video .I am waiting for your kind response .
Good sir
Nice
Sir ,Nice video, i am seeing your videos, sir i have doubt in datavalidation how to write formula for greater than less than for school fees. I have different school fee amount if total school fee is greater than received amount it show error message. for ex if 10th class fee is 10000 if received amount equal 10000 ok if its greater than 10000 it show errror message.
Ctrl D krne par aur copy krne par ye validation kam nhi krta only value enter krne par hi alert box aata h, but me chahta hu ki duplicate value ho hi na range me uske liye formula batao
Good job
Sir contact number me isnumber, length and countif farmula ek saath kese kaam karega.. Please..
Sir ji data validation me list ke saath bhi duplicate entry ka kya formula he
Hi sir. Kuch type karne ke baad Cell ko neeche ki or drag krne par duplicate entry ho rahi hai. And ye problem create kr raha hai
Sir , ye hi topic userform ke liye batao
good work
Sir restaurant ka billing ka lie excel sheet me invoice ka system sikha dijiye na plz . thermal printer me print lena hai
Okay g.. I will publish video as soon as possible
@@DeepakEduWorld thanks sir ☺
SIR AAP KE VIDEO SE MAINE BAHUT KUCH SEEKHAA MAI EXCEL PR PHARMACEUTICAL OUR HERBAL KE MFG. KE USE JANA CAHTAA HOON KYO KI MAI EK HERBAL COMPANY CHALATA HOON
+Qeaps Drmnquraishi ok g.. I will publish video..
Can you show me how to used multiple worksheet data in one worksheet without duplicate
Sir...id card ki vedio upload kro
Nice work Sir, Please tell me how to apply this formula to whole Column
Just select whole column.. And apply data validation
thank you sir
Sir excel m practice k liye notes chahiye sir
Thank you for this video.
Super video.
Question- I have data in 6 column and data are same in all columns (data like- B200089NT67) when I select data range and apply condition formatting duplicate then all duplicate highlights but when go to duplicate remove option and apply then I find error "No duplicate find value" so how to solve it.
I had also checked all data extra space using Trim and also checked cell value is correct.
Example-
Column1 Colum2 Column 3
DR000257DT TR56884QR ASG489901 DR000257DT
Deepak sir isi number wale colomn me ye restrictions lagana ho ki number minimum 10 digit ka ho to wo bhi kaise lagayenge
??
Sir f4 ko dabane se lock n hora ek sath 2 dabane padta hi kya
Aggar app id copy krrtae toh kyaa yeah work kareeggaaa
Sir ji rply toh krr doh
plz update
Dear Deepak Ji
Please share how to use vlookup for same item code but different rate for different costumer use in bill formate.
This will be very useful in macking bills
less than 2 kyun lagenge sir
দীপক স্যার আপকা ভিডিও বহত আচ্ছা লাগতা হা মে আপকা ভিডিও দেখতা হু আর খাতা মে নোট কারকে রাখতা হু❤❤❤
How do i entry & reentry match accepted
What is deffrence between or formula and formula
After applying formula and delete duplicate ,
Can we find again duplicate data as before condition..
Dear sir....
Kya hum ye formula bahar laga ke copy kar data validation me paste kar sakte hai..... plz reply
haanji sir kar sakte h
@@excademy7746 thank you jii
sir agar humen kisi ki age 18 to 30 tak ka entry ho 30 sy oper erorr alert dy
sir g my question ye hay k hum jo bhi work sheet 1 per addition and deletion karain us ki summery sheet 2 per auto update hoti rahay.
+KHALID ALI SubhanAllah okay ji... i'll publish video as soon as possible
How extend the top cell settings formula to bottom cell which are not earlier within this?
How to extent range
Nice video but i have one issue
If we copy a number which is already in the cell range from any other sheet it is not showing warning.how we avoid this issue
I trying to transfer data from one password protected sheet to other protected sheets by using macros. But since it is being password protected data from one sheet not getting transfer and error message appears. Sheets have been protected to avoid delenerate changes by multiple users. Pls advice.
Agar particular material ek column me aur uski size dusre column me hogi to..ye formula kaise lagaye
Dear sir ,
How to same value prevent duplicate entries in two columns in excel
+Soumen Bera ok.. I will publish video on this topic again
This formula is work only for row wise but i want to know formula which is work row and column both at a time (like- A1:A10 & A1:J1),
Thanks is advanced.
Sir yadi list badi hi aur vo list roj badhti Jay to usme kese is formula ko apply kare
Hello sir,
Thank you for posting videos.
Can you explain, why did you use Countif instead of other formulas? Thank you!
Pranam deepak sir. Main aap ka bahut bara fan hu aur ek student bhi hu. Aap ka yeh formula maine apply kiya hai aur duplicate entry 2nd time entry nahi ho rahi hai lakin sir ek problem bhi hai please help kijiye. Agar koi bhi data main copy paste kar raha hu to fir table me data accept ho raha hai. Agar type karu to fir problem nahi hai. Agar copy paste karu koi bhi data fir jitni bar chahu kar sakta hu. Copy paste ko kaise roka jai. Please help me. Thank u sir. Pranam
thank you for this video. but it does not show duplicate entry if we copy the data and paste. it accepts it. can you look at it?
Not working in all rows of selected coloumn... Even the error alert is not showing
Thnx sir
unable to do f4 pls suggest
Hi, Deepak! Thank you for sharing very useful videos. I have question. In formula why we are using
Less than 2 means 1 , that means only one time data can be entered/inserted
Duplicate paste na ho koi eysa formula btao sir kyunki knhi se copy krte h to paste ho jata hyn
wonderful:)
Owsm.how can i contec u..this is iram here.from maruti
Deepakeduworld2017@gmail.com
Sir isame massage nahi atometic delete ho jaye. Aisa kuch ho sakta hai kaya.
Me chahta hu ki ak sheet se dusri sheet pAr advance fillter se data aa jaye or automatic usame se dupalicate delete ho jaye. Please sir bataye
sir row or column ko ak sath kese use Kre sir just replay me
Kya karna hai dear.. Cell row or column ka combination point hota hai..
Ak ak krke karma padega
Sir mujhe vehicles number likhna h jisme 2 text 2 numbers fir 2 text fir 4 numbers aata h . Ise data validation me kaise lenge.
Please help me
hello sir why we are using
Sir isme hum ctrl +d press karte he to duplicate entry ho jati he.
Sir powarpoint ni sikgate h kya
Sir hame iske liye formula bataiye A-1234
Yadi dubara ye entry na ho
@ deepak sir mai 1k company mai working hyun mere under mai 72 empoly hai,and we 2015 se kaam kar rahe hai ,mere pass unka pura sale data hai 5 saal kaa with empoly id to mujhe unko ye data each candidate ko dena hai har 5 din ke baad jaise hi unka data khatam ho jata hai fir jab mai unko data send karu to mujhe kaise pata chalega ki maine unko kaha tak data aur jab tak kaa data diya hai... please shoot video on this and please please please revert sir..
Bhai mein socha bhi nahi tha ki castom se etna kaam kar sakte hai vo ghanto ka kaam minute thinks sir base word nahi aap ko thinks bole ke liye
😊
Hello sir excel me invoice no same save hone se kaise bache
Sir number n text dono ko entry kar k validation laga hai to kaise lagana padega
Allow number +unique value +text length??? Formula kese hoga.. Maine try kiya but nhi Ho rha
How to apply three formulas in custom data validation in excel
Deepak sir countif formula work nai ker raha hein mere excel data per.
This doesn't work when there is a slash in the entry. I am maintaining a Invoice database. When I enter the Invoice No. MH/17-18/001 twice, it should give me the warning that this is duplicate entry. Is that possible ?
Ok i will check it
Hello Sir, it's not working in ms office Excel 365 please suggest
=if(or(search(M2,C6),search(M2,D6)),"Yes","No") isme error aata hai kyuki D6 ka text M2 k sath match nahi hota to kya is error ka solution ho sakta hai , pl send this type example
Formula is workin only in case of typing duplicate content. But if u copy paste the duplicate value then it'll not work
U r right brother. Samne above value is cntrl d then duplicate also enter and copy paste also enter
Sir ye unique no. Kya hota hai please please please reply sir ......please help
Means no duplicate value
How to multiple column duplicate value no enter cell in excel
Countif ke baad
Sir, good evening.
Sir agr Mai name column me jaldi jaldi me yami6n2 type kr deti hu toh bhi data validation isko text Mann KR accept kr lega. Error nhi dega.
Aisi situation me is trike ki mistake na ho data entry me toh kaun sa formula pick kru. Mujhe Kya condition apply krni chahiye
Sir next que. Mera yeh hai ki
Agr Mai sales order department me work krti hu
Or ek customer ne mujhe ek din me 17 order diye hai, tab bhi data entry krte time uska naam baar baar repeat hoga aisi situation me duplicate value wali agr condition mne apply ki hai toh woh uska naam lega hi nhi toh Mai Kya kru
Mai yeh bhi chahti hu
Ki agr ek din me ek customer service alg alg order mile yeh bhi entry Mai kru or + agr koi duplicate entry ho rhi hai woh bhi na ho it means agr ek hi customer ke do order ek saath chhda diye hai toh woh na le
Sir aapne ye to samjha diya ki duplicate entry par kaise error dikhana h.lakin ye work kaise kar rha h ye to samjhaiye
Sir mera ms excel 2010 hai.
ek problem hai. Formula bar me (product Activation Failed) aa Raha hai.sir plz help me
okay.. i'll send you the activation key
Deepak EduWorld Ok I am waiting
hello sir