Sir you are "THE BEST TEACHER " over the net. Jitni bhi aapki tarif kare Kam hai. Maine saara excel aapke hi videos se seekha hai. I don't know how to thank you.
@Innozant2 жыл бұрын
Thanks dear...Happy Learning ❤️
@sandeepaswal89443 жыл бұрын
Sir Your skill set is something to aspire to. Very knowledgeable, and even more important in this role, an Excellent teacher and communicator. My answer is =IF(OR($A2=$E$2, $B2=$E$2, $C2=$E$2),TRUE,FALSE)
@Innozant3 жыл бұрын
Nice attempt...with different logic Tejpal sain Ka comment dekhiye aur unhone Jo answer Kiya hai ek Baar use bhi go through kar lijiye..🙏❤️♥️👍👍👍Good Sandeep.
@umerkayani79 Жыл бұрын
You are a gifted person, Sir.. May Allah bless upon you and your family..Ameen
@Innozant Жыл бұрын
Thanks Dear
@1gopalakrishnarao3 жыл бұрын
Excellent. You are igniting the sparks in the minds of the Excel users/lovers/addicts/learners to do some work in Excel. You are creating interest. You are making us to learn how to use Excel for our day to day problem solving. Thanks a lot. Great job indeed. Hope you are going to show some more tricks/tips/utilities to us in the coming videos.
@Innozant3 жыл бұрын
Thanks Gopala Sir for such a valuable and wonderful feedback.. Thanks for giving me the reason of motivation t make some good content for all of you.🙏🙏❤️❤️
@deepakkandpal2602 Жыл бұрын
=or($E$2=$A2,$E$2=$B2,$E$2=$C2) i used this formula to Conditional Formating.and its working fine. Thankyou sir🙏
@lkumar27273 жыл бұрын
kabhi kabhi lagta h kitna content dekhe....kaash ek book hoti inn sabki....jisme pura practical hota
@Innozant3 жыл бұрын
Bana dein book ..ap itne Dil se kehte Hain to collection series Practical Ka..🙂🙂❤️❤️karte jaiye..thakna Nahi hai..dear..khudko itna strong Kar lijiye ki ek waqt ane par apko lagne lgega..isse bahar Kahan se laoge Questions Interview mein..Maine sab Kar rakha h🙂♥️♥️❤️ Chaliye ab jaldi as answr kriye Jo pucha hai... waiting 🙂🙂
@lorenzoelise31213 жыл бұрын
Dear they way you teach and explain is amazing and outstanding apart from that your appearance and dressing are always well manner. Stay blessed
@Innozant3 жыл бұрын
Thanks Lorenzo Elise for such a lovely ,valuable and motivational comment.. Really mean a lot to me...Thanks dear..Will always keep your words and try hard to deliver awesome content .
@lorenzoelise31213 жыл бұрын
We arr the students of striling University Scotland your videos are helping us a lot to understand the excel although difficult to under the language but our indian friends are aldo helping us. May God blesd you with his knowledge and help you to do good for society
@Innozant3 жыл бұрын
@Lorenzo Elise ,Thanks a lot dear, Yes I started making videos for Hindi language audience, Soon will try to add caption to understand english audience as well.
@sathyanarayana49143 жыл бұрын
hii
@Learn_withkdАй бұрын
Very informative Sir 👍👍👍👍
@shahwaizkhan75173 жыл бұрын
Love you brother from Pakistan Peshawar
@Innozant3 жыл бұрын
Thanks Khan sahab.God bless You dear
@ta201119962 жыл бұрын
Thanks for the amazing teaching.
@vishalkumar-qi1ky3 жыл бұрын
this video is very help full and thank you so much sir.
@Innozant3 жыл бұрын
Thanks Vishal Ji.Happy Learning dear❤️
@naveedmuzaffar73162 жыл бұрын
Awesome outstanding marvelous 👌 excellent sir the way of interpretation data in a such simplicity manner with high value it's true sir that your every lecture enhance my productivity of work.sir is there any lecture on financial modeling? Enthusiastically waiting of your kind and response.
Hai bhai khud se try kia hai 2 months se sir ka video dekh raha hu😊😊 tum bhi same formula lagaye ho kya.
@RoshanKumar-uv2ml2 жыл бұрын
Sir, is qus. Ka ans Bada advance or simple h. 1st IF and IS Blank,0, value error then search formula laga do. Simple. But sir ek bahut complicated quarry h mere paas. Jo ki nhi ho paa rhi mujhse. Agr aapne iss cmnt ka kuch bbi Rply diya to tb m aapse wo puchunga quarry. Pls solve ya rasta dikhne ki krpa krna sir. Ty sir.☺️
@Innozant2 жыл бұрын
@innozantofficial telegram id par bhejiye query,Will see
@preetiprajapati46312 жыл бұрын
This is awesome sir 🙂 very useful 🙏
@shurawat8650 Жыл бұрын
HELLO SIR LAST VIDEO CONDTIONAL FORMATTING PRACRISE FILE ISNT IN THE PRACRISE FOLDER
@manojsable84823 жыл бұрын
Usefull data nice massage sir
@Innozant3 жыл бұрын
Thanks Manoj Ji♥️♥️🙏
@govindsharma91212 жыл бұрын
Sir you are super
@rajaalmeida4914 Жыл бұрын
Very nice
@anooparora2515 Жыл бұрын
Thanks Sir!
@heartpirates-qt6ws Жыл бұрын
the formula of this question is =if(isblank($e$5),0,search($e$5,a5&b5&c5))
@muhammadsaqlain51622 жыл бұрын
very very nice trick
@user-jc6te1vm8v3 жыл бұрын
sooo talented u r sir.... amazing
@Innozant3 жыл бұрын
Thanks dear ❤️🙏 for valuable feedback 🙏
@Excelpro753 жыл бұрын
=OR($A2=$E$2,$B2=$E$2,$C2=$E$2) This is formula sir. I applied it is success.! 🤣Thank you
@Innozant3 жыл бұрын
Good 👍❤️
@bishtlokesh12973 жыл бұрын
These is useful video nd very helpful ❤️
@Innozant3 жыл бұрын
Answer Ka wait ..Jo Ques pucha hai..bataiye Loeksh Ji❤️🙂
@saneeshkrishna38183 жыл бұрын
Dear Sir, the below formula for your question =OR($A25=$F$25,$B25=$F$25,$C25=$F$25,$D25=$F$25) for fill the colour =$F$25="" for no fill when the search box is empty
@Innozant3 жыл бұрын
👍❤️
@itzPrincesoni2 жыл бұрын
Sir, MIS ki information video bnao ek, uska use, etc
@Innozant2 жыл бұрын
Already Available hai career guide playlist me
@azadsingh74523 жыл бұрын
This is helpful video
@RahulChauhan-ts8xt2 жыл бұрын
Sir conditional formatting data se bina conditional formatting lage data ko kaise separate krein.
@Innozant2 жыл бұрын
Filter features ya filter function available hain aapke paas.
@Anil-se9wp3 жыл бұрын
Hi sir,,, excellent demonstration... Libre office calc videos please....
@Innozant3 жыл бұрын
Thanks..ok sure will try this make the same
@kinghundred3 жыл бұрын
very good sir
@tjr14212 жыл бұрын
Sir ek query hai. Jab source se list copy karke dusre sheet pe paste karte hai to remove duplicate, taki uski drop down list bana sake, tab sir main sheet se validation box jab open karke source me wo list add karne k liye dusre sheet se jaha list bana rakhi hai, excel 2007 allow nahi karta. Do I need to do any setting for this problem?
@RoshanKumar-uv2ml2 жыл бұрын
Simple h, koi settings nhi ho skti. Excel uss kaam ko krne k liye nhi bana. Advanced Excel hi kr skta h. Mtlb new 2022 wala
@tjr14212 жыл бұрын
@@RoshanKumar-uv2ml no bro muje solution mil gaya. Excel 2007 me agar hum naming range de toh dusre sheet pe validation box me direct uska name range type kare toh hojata hai.
@smitadivarekar14752 жыл бұрын
Thank you sir....
@Innozant2 жыл бұрын
Thanks
@devendergusain89743 жыл бұрын
thnkx sir 200%
@dakshbachhety972 жыл бұрын
Sir I love u 😘
@Innozant2 жыл бұрын
Thanks
@rajadey15522 жыл бұрын
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🙏🙏🙏🙏🙏🙏🙏
@AmitGupta-bl2iu2 жыл бұрын
Best sir
@meditationmusic64823 жыл бұрын
So nice Sir ji.
@Innozant3 жыл бұрын
Thanks Sanoj ji..hv a great day
@meditationmusic64823 жыл бұрын
@@Innozant thank 😊 you sir
@amitca22 Жыл бұрын
hi could you please solve this or made a video on data validation of date where column names are order id, order date ,ship mode, shipping date apply data validation on shippng date where shipping date is after or greater than order date.
@paras58613 жыл бұрын
Zabardast!
@Innozant3 жыл бұрын
Thanks Dear
@shoaibahmed7257 Жыл бұрын
done
@krijaygaming35062 жыл бұрын
Sir aap bihar me kaha se ho i am from pupri, sitamarhi, bihar
@Innozant2 жыл бұрын
👍❤️
@paramjeet975singh33 жыл бұрын
Sir isme underline kaise karege Bold Italic regular Yahi hai Underline wala kaise hoga sir pls batana Thank sir
@sawaimalhi84393 жыл бұрын
kiya baat hai sir aaap ki
@Innozant3 жыл бұрын
Thanks dear
@pawanwakale88013 жыл бұрын
sir is drop down list ke end me aapne jab select kiya drop down source validation se woh humare isme nhi ho raha woh sheet se dusre me move nhi ho raha isme ruk gye hum ,,kya excel ka koi issue hoga sir yeh
@Innozant3 жыл бұрын
Matlab..kya kar re hain to issue aa raha hainye btaiye aap?
@harshadshikerkar64483 жыл бұрын
Hi I have trouble in my excel. I have merged 2 rows and 10 columns and then I have given data validation with drop down list. Till this function ok. But after that I have given conditional formating with specific text with specific colour for that merged cell. Then if I choose from drop down list then my cell getting half with different colour and half with another color. And half is not exactly half of cell. It's random Please guide regarding
@Innozant3 жыл бұрын
Applied conditional Formatting may mismatch
@monirhossainhtbaddagpsnabi83752 жыл бұрын
10 or 13 or 17 digit NID number inport furmula ? give me please
@amandeepbadgujjar7096 Жыл бұрын
Hello sir good morning, sir mene question ko solve kiya leki jis cell me search karna h uske background me bhi colour show kar raha hai mera answer IF(OR($B2=$E$2,$B2=$E$2,$B2=""))->last vala colour ke liye h. Sir ye sahi h n or sir background ka solution bhi bata di giye 😇😇😇
@AbhishekPandey-je5ql3 жыл бұрын
Sir first wale formula se, agar bold k baad italic click krte hain to bold chala jaata h, bold krte hain to italic chala jaata h. Please guide
@Innozant3 жыл бұрын
Dono ke liye formula apply kriye
@AbhishekPandey-je5ql3 жыл бұрын
@@Innozant sir apply dono k liye kiya hai, but ek baar me ek hi lagta h.
@priyankabansal63813 жыл бұрын
Thanku sir
@Innozant3 жыл бұрын
Thanks Priyanka .🙏❤️Hope you done the Practice of data validation 🙂
@chowdhurysunzidmahbub792 жыл бұрын
How to increase Dropdown font size???
@Brothersvlog-20243 жыл бұрын
Sir agar koi employ h or uska hume dikhana h ki agr wo present h to uski present High light ho absent par click kre wo hight light ho kitne din wo office aaya wo count dikhe ..sir ye samajh ni aa raha k ek employ ka sara data uske naam pr click kre to count show ho present pr click kre present High light ho wo ni ho raha sir
@Innozant3 жыл бұрын
Anjali data validation list creatw kijiye usme P A aur Total Employee yw likho then highlight karna hai to conditional formatting me jake new rule aur condition apply kriye Using If function.Aap try kriye yadi nhi hota hai aapse to mujhe aap excel sheet share kar dena query likhke ki aap kyabchahte ho.Will guide you for the same. @innozantofficial telegram id par bhejoye.. Dont worry ye bht simple sa issue hai apka ho jayega.❤️🙏 Thanks for being part of Innozant Family ❤️
@Innozant3 жыл бұрын
Hua problem solve aapka?abhi bhinydi issue face kar re hain to @innozantofficial telegram id par auery send kren..will guide you
@Brothersvlog-20243 жыл бұрын
@@Innozant ni hua 😭 mene kosis ki bahut employ ka sara data ek jgha show Krna h ...sir jaise hume dekhna h k employ month me kitne din office aaya wo count kaise kre ....sir hume dikhana h k ...agr hum Present pr click kre to present highlight ho jaye absent pr click kre wo hight light ho jaye weekof High light ho ...jitne din aaya office wo aa jaye ..sir ye hm uske name pr click krne par kaise nikale sab
@Innozant3 жыл бұрын
@@Brothersvlog-2024 Conditional Formatting se easily kar sakte hain na custom function use karke using new rule,conditional formatting ke advanced video dekhiye aap kar payenge khudse nhi hota hai the sheet format mujhe @innozantofficial telegram id par bhejna
@meditationmusic8813 жыл бұрын
excel me table me date me 2020_2021 and 2021_2022 ko alag kaise kar sakte hai
@Innozant3 жыл бұрын
Didnt get you,Query explain kijiye detail me
@MrRashmimallick3 жыл бұрын
Sir, Pls help to provide formula for nth match by using vlookup and indirect...You have done for 1st and 2nd match...
@Innozant3 жыл бұрын
Ok..will add it in upcoming videos
@MrRashmimallick3 жыл бұрын
@@Innozant Thank you Sir
@MrRashmimallick3 жыл бұрын
@@Innozant Other day u r telling about the solution through index match and small. Pl also include this in your upcoming videos
@vishakhavishakha8673 жыл бұрын
All boder kese lagaya sir
@Innozant3 жыл бұрын
Alt h b a Vishakha ji
@satishojha62403 жыл бұрын
We use logical function IF(isblank($E$2),0,Search ($E$2,$A2&$B2&$C2)) I hope ye sahi hoga .Thanku sir for this video good night.
@Innozant3 жыл бұрын
👍❤️ good Satish ji
@aaradhanasoni8991 Жыл бұрын
👌🏻👌🏻
@atulshukal40723 жыл бұрын
E2="","",A2 formula Sir
@pradeepjangid4903 жыл бұрын
शब्द नही हैं सर तारीफ के लिए
@Innozant3 жыл бұрын
❤️❤️❤️
@pradeepjangid4903 жыл бұрын
@@Innozant सर मेरी एक query हैं excel की मुझे आपका mail id बताओ ताकि एक सैंपल फ़ाइल भेजकर आपको query बता सकू
@Innozant3 жыл бұрын
@innozantofficial telegram id
@ShyamSundar-mn4vm2 жыл бұрын
My formula for CF =ISERROR(SEARCH($E$2,$B2))=FALSE
@SarojKumar-ro7is3 жыл бұрын
👌
@Innozant3 жыл бұрын
Thanks
@gauravbhatia79873 жыл бұрын
Ok sir i gotit Select the data a2:c19 Then got the condition formatting and in formula =if(or(a2=e2, b2=e2, c2=e2),true,false) then choose a someone colour and sir isme jo e2 hai vo fix rahega or jo c2, :b2, a2 ka column fix rahege maine apply kiya hai sahi aa or blank cell rakhne se koi condition nhi lgti sir
@Innozant3 жыл бұрын
Nice attempt Gaurav,,Aap Tejpal sain Ka comment padhiye aur Jo formula use Kiya hai unhone use bhi kijiye ❤️❤️🙂m really happy ki aplog interest Lete Hain Kuch Acha seekhne ke liye .🙏❤️
@letsdomistakes5 ай бұрын
=OR($B2=$E$2,$C2=$E$2)
@rameshmeena75823 жыл бұрын
मैं यह जानना चाहता हूं ।सेलेक्ट एरिया में पूरा डाटा वैल्यू कैसे चेंज होता है।ड्राप-डाउन से। मैं चाहता हूं कि सलेक्टेड एरिया मे ही पूरा डाटा चेंज हो जाना चाहिए। जिस प्रकार "Hide/Show" data मे होता है सलेक्टेड एरिया मे।सलेक्टेड एरिया मे ड्राप-डाउन से पुराना डेटा की जगह नया डेटा आ जाये
@Innozant3 жыл бұрын
Sheet share kijiye query ke saath @innozantofficial telegram id
@rameshmeena75823 жыл бұрын
Sir send your Gmail ID so that I can send my file because I do not know run the telegram id
@ShyamSundar-mn4vm2 жыл бұрын
You can do it with the help of advanced filter
@msexcelgooglesheet3743 жыл бұрын
Sir ji there is a problem in comment section, One comment is not showing Tejpal saini Jiska comment apne dekhne ke liye kaha hai Confusion where is the comment.. 😕
@Innozant3 жыл бұрын
Oho..isi video me to hai niche..koi nhi aap if(isblank($E$2),0,search($E$2,$A2&$B2&$C2)) ye use karna ..ok..good night
@msexcelgooglesheet3743 жыл бұрын
@@Innozant thank u very much sir 😀🙏❤️. But comment is not showing sir ji, you can check through in incognito mode not from official channel of innozant.
@Innozant3 жыл бұрын
Matlab...All comment is not showing?I am able to see all the comments .
@msexcelgooglesheet3743 жыл бұрын
Yes all comments are not showing, You can see through your innozant youtube channel but when you open this video in chrome incognito some of the comment will not be show in comment section. I hope sir ji u got it what i want to say......
@ishutiwari55673 жыл бұрын
@@Innozant sir isse easy formula to mujhe =OR($A2=$E$2,$B2=$E$2,$C2=$E$2) ye wala lga. ye jo apne formula type kiya h isme kuch logic smjh nhi aya. isblank se to 0 value ayegi means "false" ,to kuch highlight nhi hoga.itna to theek h but search function to kuch bhi value de dega according to the position of text.uske base pe kese highlight hora h.i wonder😳 mene evaluate bhi krke dekha formula but logic amjh nhi aya apke wale formule ka.😕