Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Course Website :bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ⬇ Download Video in APP ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : skillcourse.in/
सर् आपने बहुत ही सटीक तरीके से बताया है। पर डुप्लीकेट वैल्यू भी चाहिए हो तो क्या करना होगा जैसा आपने वीडियो के शुरू में बताया है yes or no उसको भी शेयर कर दीजिए।
Hi sir your method is very easy and your way of teaching is very good i like it with this formula can we add that some specific length of our text or number i mean can we keep both the validation e.g restriction of duplicate and specific length of our data
thank you sir i tried but i can't keep 2 or 3 validation at same column because i am not an expert i trying to learn two year ago i needed a list with name and ID# because of short time i gave this task to my friend he did a lot of mistake e.g double number, space and long number our ID # is of 15 digits somewhere he typed 16 and 14 etc
very nice keep the good work , i have also need one help , if you can please, i have 1 excel sheet , where multiple user sharing that excel sheet lot of time that excel show msg this file is lock while saving , then we need to find out who is forget press ok after saving the sheet
If you could please help me , how to find a specific value from a string , just like we do Vlookup, I tried search formula but it didn't work , or I couldn't make it... Case is there is an Data on two sheets, I have an unique codes in a column , wanted to search the same way we work with Vlookup , but here the problem is this value has to be extract from a string... So how can we pull that the specific value is in the specific string. It should show the unique code just nest to the string cell....
Good morning sir Aap ke videos bhut achhe hotel Hain But muhje ek problem hai ki Maine jis bhi cell me colours hai to use count kese kren Mujhe colour count krna hai
Hello Sir, I have a question regarding creating a tracker file . I have a data in sheet1 B2 as' Bank transaction' and A2 is a date column whereas C2 is a amount column . Now in sheet2 the same information is available but in different row & column ,here in B10 data is available as 'Bank transaction' and F4 is a date column .whereas amount is not available. So my question is like how is it possible that if in sheet1 I will put the date and amount in respective column and it should automatically find data and date in sheet2 and write the amount next to Bank transaction I,e in F10 ,under the date column . Hope you understand my question.If not please do comment with your reply. Thanks
thanks .. query: a range of dates from 1-jan-2018 to 30-dec-2018 , please could you advise how to split in QTR1 , QTR2,QTR3 AND QTR4 Thru a formula.. appreciate ur quick response ...though you have a busy schedule !
Sir ek meri bi query hai.......same value hai but ek positive me or ek negative me or dono value 0 ho rhi hai cross me or me chahta hu dono value ke samne contra fill hokar aa jye please sir help me
=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 solve a query I have an folder and I have 100 folders in that folder and I want that 100 folders name be show in excel sheet automatic on one click can you solve this query
sir if you press enter command that time the data validation will comes in active state read the cell and find the duplicate values if you drag or press ctrl+ d then the data validation cmd will not be read there so that's why this problem is there until and unless you do not press enter then this above tricks is not useful
Satish Sir, मुझे Array function, Power-query और Power-pivot सीखना है | Array function के video में एक बात ज़रूर बताए कि कब ctrl+shift+enter करना है और कब { } लगाना है, ये difference ज़रूर बताए | ; )
I WILL TRY A LOT OF TIME. BUT TEXT TRIM FORMULA IS NOT WORKING. PLS. HELP ME. FIRST I SELECT COLUMN, THEN GO TO DATA VALIDATION, THEN SELECT CUSTOM THEN TYPE FORMULA = B1=TRIM(B1) THEN OK. PLS NOT WORKING. PLEASE HELP ME. THANKS.
sr me excel me koi bhi digit type karta hu suppose 1 to 0.01 a rha h or 2 type 0.02 number setting me koi mistake ho gayi plz solve my problem sr thank you
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
The way u explain no one else does, thanks a lot, 👍
Thank you very much sir.your teaching style is very good.I likes excel and VBA series
THANKS A LOT DEVJI PATEL SIRJI FOR WATCHING MY VIDEO..AGAIN THANK U SIR...
समझ मे आया सर। बस थोड़ी practice करनी होंगी। 👌👌👌
thanks amol
A big big thanks to learn more channel for quickly solved veiwer problem ....
THANKS VIRAL INDIA (TARUNJI) THANKS A LOT FOR BEING MY REGULAR VIEWER
A very thankful to learn more channel for solving quickly viewer querry
Thank you Sr
thanks Traun ji thanks lot for being my viewer hope you will share my video with your friend circle
Thanks sir I saw your all video. Really it is very useful.
THANKS FOR WATCHING THANKS A LOT FOR SHARING YOUR HEART FEELINGS ABOUT MY VIDEOS
सर् आपने बहुत ही सटीक तरीके से बताया है। पर डुप्लीकेट वैल्यू भी चाहिए हो तो क्या करना होगा जैसा आपने वीडियो के शुरू में बताया है yes or no उसको भी शेयर कर दीजिए।
Work was hard but you could very easy
SIKANAR JI THANKS FOR WATCHING THANKS A LOT
Hi sir your method is very easy and your way of teaching is very good i like it
with this formula can we add that some specific length of our text or number
i mean can we keep both the validation e.g restriction of duplicate and specific length of our data
ok that's really interesting question i will check it if it is possible i will let you know aamir bhai
thank you sir
i tried but i can't keep 2 or 3 validation at same column because i am not an expert i trying to learn two year ago i needed a list with name and ID# because of short time i gave this task to my friend he did a lot of mistake e.g double number, space and long number our ID # is of 15 digits somewhere he typed 16 and 14 etc
very nice keep the good work , i have also need one help , if you can please, i have 1 excel sheet , where multiple user sharing that excel sheet lot of time that excel show msg this file is lock while saving , then we need to find out who is forget press ok after saving the sheet
If you could please help me , how to find a specific value from a string , just like we do Vlookup, I tried search formula but it didn't work , or I couldn't make it...
Case is there is an Data on two sheets, I have an unique codes in a column , wanted to search the same way we work with Vlookup , but here the problem is this value has to be extract from a string...
So how can we pull that the specific value is in the specific string.
It should show the unique code just nest to the string cell....
Sir, plz suggest how to apply countif with Len function in data validation in same column in excel 2007
Very useful
Thanks sir
Thanks bro for watching this video......
Gd mrng
Thnks a lot very useful video
Sir Very good video very helpful.....
THANKS RADHEJI
Message is not showing
sir,
data validation se sambandhit sabhi formulla pr ek special video banaye.
Good morning sir
Aap ke videos bhut achhe hotel Hain
But muhje ek problem hai ki
Maine jis bhi cell me colours hai to use count kese kren
Mujhe colour count krna hai
Hello Sir,
I have a question regarding creating a tracker file .
I have a data in sheet1 B2 as' Bank transaction' and A2 is a date column whereas C2 is a amount column .
Now in sheet2 the same information is available but in different row & column ,here in B10 data is available as 'Bank transaction' and F4 is a date column .whereas amount is not available.
So my question is like how is it possible that if in sheet1 I will put the date and amount in respective column and it should automatically find data and date in sheet2 and write the amount next to Bank transaction I,e in F10 ,under the date column .
Hope you understand my question.If not please do comment with your reply.
Thanks
Very good sir
Nice video 👍
Sir exel main different tab sheet different data hai koi adhikb hai koi kam all sum total kese kare
thanks .. query: a range of dates from 1-jan-2018 to 30-dec-2018 , please could you advise how to split in QTR1 , QTR2,QTR3 AND QTR4 Thru a formula.. appreciate ur quick response ...though you have a busy schedule !
Banwari Lal ok sir i will send the file to you related ur query
sir aapko aapki query ka mail kiya tha check kiya na aapne
Hello sir,
How we can make multiple time data validation for same cell?
Awesome
Sir ek meri bi query hai.......same value hai but ek positive me or ek negative me or dono value 0 ho rhi hai cross me or me chahta hu dono value ke samne contra fill hokar aa jye please sir help me
=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
Hi sir. Ek problem hai.wo ye ki yadi maine iss line me kisi bhi cell ko drag kr diya to duplicate value enter ho rhi hai.aisa kyo?plz reply
So thanks sir you are great sir
Hi Sir, How to prepare And visualize below details onto MIS report - Measure Defects,Part description, Raised against dept ,sub section dept Nd TAT.
Sir solve a query I have an folder and I have 100 folders in that folder and I want that 100 folders name be show in excel sheet automatic on one click can you solve this query
bhai wo excel ka file management video hai please watch and try it
Thanks
thanks bro for watching this video...........
if above figure is taken thru CTRL+D in the below cell , then no error message for duplicate appear ..what is reason pls advise
sir if you press enter command that time the data validation will comes in active state read the cell and find the duplicate values if you drag or press ctrl+ d then the data validation cmd will not be read there so that's why this problem is there until and unless you do not press enter then this above tricks is not useful
i already check this error while working on it i will find out solution on it
Nice video sir
THANKS PRABHAKAR SIR
Mast maja aa Gaya sir
THANKS VIKAS THANKS A LOT
Satish Sir,
मुझे Array function, Power-query और Power-pivot सीखना है |
Array function के video में एक बात ज़रूर बताए कि कब ctrl+shift+enter करना है और कब { } लगाना है, ये difference ज़रूर बताए | ; )
OK PUNEET JI ARRAY KA EXACT KAM HOTA KYA HAI EK VIDEO ME EXPLAIN KARTA HUN
Sir g
Or ham chahte h ki contact 10 nbr se kam ya Jada inter na ho
Plz rply
Nice Tip!!!
But You forgot to explain How to accept the duplicate value??
OK I WILL CHECK THIS VIDEO AGAIN THANKS FOR REMINDER
देखा क्या सर्
Sir stock invantari ka video banavo
greate sir
Thanks ramkishanji thanks a lot for watching
Invantari manejmet kese karte he
Excel mein =Randbetween(1, 8) ko stretch karne par duplicate value deta hair jo game nahi chahiye. Pls look into this
NICE ONE
Thanks a lot Mohd ji for watching my video....
How to apply both formula in single cell through data validation
I WILL TRY A LOT OF TIME. BUT TEXT TRIM FORMULA IS NOT WORKING. PLS. HELP ME.
FIRST I SELECT COLUMN, THEN GO TO DATA VALIDATION, THEN SELECT CUSTOM THEN TYPE
FORMULA = B1=TRIM(B1) THEN OK. PLS NOT WORKING. PLEASE HELP ME. THANKS.
NICE
Thanks a lot for watching this video.... visit my channel and watch more video.....
Excel main cashbook, ledger or receipt payment kaise banai
sir trening file kaise download kare
Thanks sir
thanks jiteshji and hope you will share with your friends
Learn More definitely sir ... waiting for your next video
Sir jab data copy paste karte hai to ye data validation kaam nahi karte.iska koi solution hai????
sir please help me mai jab bhi excel me hindi me sharma likhta hu to sha gayab ho jata h please help me
aap kaunsa font use karte hai ramkishan ji kruti dev 10 ay koi aur
+Learn More (Satish Dhawale) kruti dev 010
Wa sir
thanks sirji for watching this video...........
Ok sir
Copy and paste karene main accept ho joyta hain.. copy paste se kase roke...
abhi recently video banaya hai ji how to restrict copy paste in excel sheet
sr me excel me koi bhi digit type karta hu suppose 1 to 0.01 a rha h or 2 type 0.02 number setting me koi mistake ho gayi plz solve my problem sr
thank you
Yes click on number setting and set custom setting decimal places to 0 GIVE ME YOUR EMAILD ID I WILL SEND YOU SOLUTION
Learn More tarunkhinchirock@gmail.com
please check your inbox and thanks for being my regular viewer
Nice sirji & 10nks for calling me bt i still wait my query solutions 😊
OK SIR I DID YOUR VLOOKUP ON 2007 OFFICE IT WORKS PROPERLY PLEASE CHECK YOUR MAIL
10ks ji i hv rply plz check email
mera 1 excel file he aur wo password protect he aur mai uska password bhool gaya hu.so pls guide us
Yes sir
🔥🔥🔥
👌👌👌👍🏻👍🏻👍🏻👍🏻👍🏻
THANKS SIR
आप ने जो musuc बताया सीखने मे वह म्यूजिक नही बताया डबल रखने का तरीका भी नही बताया धन्यवाद
Data validation bhi ise restrict nhi kr pa raha.
Sir sirf 10 mobile no accept hone chahiya aur unme alphabetical na include na ho
Agar first mobile no. m 1 na ho to
Matlab 10 digits of mobile no no included alphabetical
sir i didn't find your reply ..pls can you forward me again ! sorry to trouble u !
Sir nahi samaj aaya
OK AAPKA EMAIL ID DIJIYE PLEASE AAPKO AUR DETAIL ME MAIL KARTA HUN
Jese aapki same value ke samne true, false aa rha hai
Thanks sir
thanks for watching vikash ji