Sir, Apka next video ka Date boldijiye. Appne kafi din bad video upload Kia. Meyto bahut paresan hogaya tha ki sayad appka video Miss hogaya hai. Kindly part number of video it's help to identify part to part.
Ohh Annaaa Xlookup ke diffrent uses formula pee iss janam mein hame video milega ki nahi 2mahine se bol raha hun Xlookup or xlookup ke array ke sath video banao.
सर नमस्ते.. सर एक्सेल शीट फाइल path अगर मैनुअल चेंज करते हैं तो कनेक्शन फाइल से कनेक्शन हट जाता है.. तो कनेक्शन हटे नहीं.. अपडेट अपने आप हो जाए तो कोई विडिओ लिंक देदो. Solutions चाइये
Excel Me ek hi cell mujhe do formula lagana hai-1.Agar starting date aur end date malum hai to dono ke beech ki time DD.MM.YYYY formate me.2.Aur yadi sirf starting date hi keval malum hai to starting se today tak ki time DD.MM.YYYY formate me kaise karen?
sir 1 qus ka solution lena h apse, ek range h 30 column m jisme 7,8, 8.5,9,9.5,10 value pdi h hmko 9 s uper ki value ko sum krna , jaise 9-10 m 1 , 9-11 m 2
If a Student gives a Test of 3 subjects and he is "absent" in one subject, then in remark "it should show - Absent". Could you please make a tutorial on it.
Sir mujhe problem ho raha hai aapke download videos ko mein offline nhi access kar pa raha hu mujhe wahi download videos dekhne ke liye mujhe net ko open karke rakhna ho raha hai
Sir please help. Example. If there is 5 in column A then write XYZ and if there is 18 in column A then write ABC and if there is 12 in column A then write pqr If there is 28 in column A then write MNO Which formula will be used for this? ?
I am placing/writing a formula in cell C1 In A1 - Its EXPIRY DATE In B1 - Its RENEWAL DATE =IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT") The above formula is working. Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()
Student data में boy, urban, gen एक साथ हो तो A टाइप हो, boy, urban, sc हो तो B टाइप हो, boy, rural, sc हो तो c टाइप हो, फॉर्मूला बतायें प्रैक्टिकल के साथ।
Sir ji , nice tricks..... Sir ji ek question: "I was try to create simple data entry file . Employee information : Name /address/gender/Birthday dates/ joining date / Designation / contact number * Command button * Click Command button to open VBA userform * Fill data in userform * Save data in Table formats * Anything serachable box making (How to data entry using userform for Table ?????????) Please sir biggest helps for office employees & Database mantain
Guruji राधे राधे, एक क्वेरी सॉल्व कर दीजिए, एक कॉलम में बहुत से डुप्लीकेट स्कूल के नाम है, तो मैं चाहता हूं कि , दूसरे कॉलम में उसके सामने, स्कूल की संख्या लिखी आ जाए की, चार है, और नीचे की row blank रहे, सिर्फ एक बार लिखा आए 4, और फिर दूसरा स्कूल 10 बार है तो सिर्फ एक बार 10 लिखा आ जाए, ऐसा गर बार हो qk बड़ी लिस्ट है । तो कोई फॉर्मूला बताइए। Thanks ॐ
PLEAES RESOLVE BY IF FORMULA ID DATE RESULT 1001 25-08-2024 1 1001 26-08-2024 2 1001 27-08-2024 3 1001 28-08-2024 4 1002 29-08-2024 1 1002 30-08-2024 2 1003 31-08-2024 1 1003 01-09-2024 2 1003 02-09-2024 3 PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column
Hello sir namaskar me Harsh sonkar form sehore Mujhe apse ye puchna hai ki agr hmre pass VBA ki file hai or vo password protected hai usme hum kuch bhi change or code nhi dekha sakte bine password open kiy hue tab hum uske code or password ko kese dekhe. Me apko us file ka attachment share krta hu plz share ur email so I attached the file
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
ITNI ASANI SE SAMJA DIA KIA BAT HAI JANAB ECXELLENT.
Very well understood sir thank for this explanation
sir aap bhaut acche sai example dete ho osm sir 😍😍😍😍
Guru dev ho app❤ thank you apse bohot kuch sikha and apply vi kiya ❤
Tussi great ho
Very well explained sir ..😊
Great going
Buhat acha samjhaya aap ne thanks😍😍😍🥰🥰🥰
well simpliefied with good illustrations.
Very well explained sir🙏❤️
🎉🎉🎉
Very good sir
Many many thanks 😉😉😉😉😉😉😉😉😉
Nice video
Thank u sir🥰🥰🥰🥰🥰🥰
Awesome class bhai ❤
Full of knowledge
Thank you so much sir ❤
superb teaching skill sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
God tussi great ho awesome
Keep watching the new videos I am uploading.
Very nice video 👍👍👍👍
Thank you so much ! 🙏
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Thank You Sir.
You are most welcome
Good teach
First comment
thks. boss ur videos will be effective wirh eccel files or its just s lecute❤
Thank you so much sir
Keep watching
Pls make a video on is error function
Sir, Apka next video ka Date boldijiye. Appne kafi din bad video upload Kia. Meyto bahut paresan hogaya tha ki sayad appka video Miss hogaya hai. Kindly part number of video it's help to identify part to part.
Congratulations on your first 314K followers, may you reach 500K soon. 💖
Thanks and welcome🤩🤩🤩🤩🤩🤩
Ohh Annaaa Xlookup ke diffrent uses formula pee iss janam mein hame video milega ki nahi 2mahine se bol raha hun Xlookup or xlookup ke array ke sath video banao.
Really good
Thank you! Cheers!
Thankyou sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Sir agar for example any 4 documents me se 2 compulsory ho to konsa use kre please bataiye
Or ka kam if me bhi ho skta hai kya sir.. only sales amt important hai greater then 1lac
Sir aap SAP Kyou nahi padhate hai please🙏🙏SAP Bhi padhaye
Sir monthly time kise gama karen
Hello Sir. Nepal ke liye vi hai kya certificate. Reply me.
सर नमस्ते.. सर एक्सेल शीट फाइल path अगर मैनुअल चेंज करते हैं तो कनेक्शन फाइल से कनेक्शन हट जाता है.. तो कनेक्शन हटे नहीं.. अपडेट अपने आप हो जाए तो कोई विडिओ लिंक देदो. Solutions चाइये
😂😂😂 Intro toh mast tha
Sar iski Ek Aur video laoo Jiske andar if and aur 3 example ek hi Iske andar hun usmein Ek bhi Laga Ho and bhi Laga Ho Aur Bhi Laga Ho
Excel Me ek hi cell mujhe do formula lagana hai-1.Agar starting date aur end date malum hai to dono ke beech ki time DD.MM.YYYY formate me.2.Aur yadi sirf starting date hi keval malum hai to starting se today tak ki time DD.MM.YYYY formate me kaise karen?
Waiting for your response
sir 1 qus ka solution lena h apse, ek range h 30 column m jisme 7,8, 8.5,9,9.5,10 value pdi h hmko 9 s uper ki value ko sum krna , jaise 9-10 m 1 , 9-11 m 2
koi bhi iska ans de do,
इसके लिए आप SUMIF Function का इस्तेमाल कर सकते है।
How to use less than or equal to in excel if differs value in one column
Is case may nested if bhy use karsakty hy?
As nested if and and function may difference kya hy?
Sir typing course lao tips
If a Student gives a Test of 3 subjects and he is "absent" in one subject, then in remark "it should show - Absent".
Could you please make a tutorial on it.
Advance excel new video please
Sir mere ko advance exel ka batch lena h kha se lu
Sir mujhe problem ho raha hai aapke download videos ko mein offline nhi access kar pa raha hu mujhe wahi download videos dekhne ke liye mujhe net ko open karke rakhna ho raha hai
apna hindi sudharo kripya
Sir please help.
Example.
If there is 5 in column A then write XYZ and if there is 18 in column A then write ABC and if there is 12 in column A then write pqr If there is 28 in column A then write MNO
Which formula will be used for this? ?
I have purchased course but I don’t get practice file please help me
💙💙💙
Sir unfortunately this app doesn't work in our country Pakistan 😢😢 i am beg fan and student of you dear sir fromm Pakistan.....
I am placing/writing a formula in cell C1
In A1 - Its EXPIRY DATE
In B1 - Its RENEWAL DATE
=IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT")
The above formula is working.
Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()
Sir aapk ka app me enter nahi hoparaha hai
Student data में boy, urban, gen एक साथ हो तो A टाइप हो, boy, urban, sc हो तो B टाइप हो, boy, rural, sc हो तो c टाइप हो, फॉर्मूला बतायें प्रैक्टिकल के साथ।
❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Hy my dear sir aapse request h sir aap please app ko iPhone k liye bhi lonch kre please 🙏🏻
😂😂😂😂 nice
EK hi baat ko baar baar kyo repeat kar rahe ho bhai
Sir ji , nice tricks.....
Sir ji ek question:
"I was try to create simple data entry file .
Employee information :
Name /address/gender/Birthday dates/ joining date / Designation / contact number
* Command button
* Click Command button to open
VBA userform
* Fill data in userform
* Save data in Table formats
* Anything serachable box making
(How to data entry using userform for Table ?????????)
Please sir biggest helps for office employees & Database mantain
Mi k
Guruji राधे राधे, एक क्वेरी सॉल्व कर दीजिए, एक कॉलम में बहुत से डुप्लीकेट स्कूल के नाम है, तो मैं चाहता हूं कि , दूसरे कॉलम में उसके सामने, स्कूल की संख्या लिखी आ जाए की, चार है, और नीचे की row blank रहे, सिर्फ एक बार लिखा आए 4, और फिर दूसरा स्कूल 10 बार है तो सिर्फ एक बार 10 लिखा आ जाए, ऐसा गर बार हो qk बड़ी लिस्ट है । तो कोई फॉर्मूला बताइए। Thanks ॐ
आप countif का फॉर्मूला यूज़ करे हो जायेगे
How to get practice file
EXCEL ME PAITAL SENTECE SE SMALL SENTENCE ME KAISE AYEGA
Lower ka formula lag ke
=Lower(jis cell me ya Jo word/text ko lower me convert Krna h vo cell ko ()isme likhe ke Entre kr do
=Lower(cell b2) Entre
PLEAES RESOLVE BY IF FORMULA
ID DATE RESULT
1001 25-08-2024 1
1001 26-08-2024 2
1001 27-08-2024 3
1001 28-08-2024 4
1002 29-08-2024 1
1002 30-08-2024 2
1003 31-08-2024 1
1003 01-09-2024 2
1003 02-09-2024 3
PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column
2
Data kuch bhi nahi dikra Sir wo aapko hi dikra
Too much graphic bro
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Hello sir namaskar me Harsh sonkar form sehore
Mujhe apse ye puchna hai ki agr hmre pass VBA ki file hai or vo password protected hai usme hum kuch bhi change or code nhi dekha sakte bine password open kiy hue tab hum uske code or password ko kese dekhe. Me apko us file ka attachment share krta hu plz share ur email so I attached the file
sir i want to take premium course pls provide your contact for payment
Thank you sir ji 🙏🙏🙏
Most welcome