Thanks i was looking for this duplicate formula I need it . I tried myself before but don't have solution now I do. So happy. Usually I was selecting all range .
I am a real big fan of your sir.... Your all videos helps me.... Many ways.... I love your teaching style.... And also follows it.... When I am with my students.... I just remember your teaching style... And follow it... In my... Class... All my students... Are felling happy 🥰🥰🥰🥰🥰
hi, I am frm Tamilnadu. Your videos are very useful . Have been learning both excel formulas, tricks, difficult tasks and Hindi Language. Your way of explaining step by step is exemplary. Thank-a- lot. Ravichandran. H
Sir Good after noon. I m your subscriber and I want to know a complete tutorial on time calculation in ms excel. Plz share and upload a tutorial video. I will be thankful and greatful to u. Regards.
10:21 sir i think apka ye conditional formatting ka formula always shi nhi hoga kyoki agr 1 se jyada duplicate hue to countif formula use highlight nhi krega you should use= countif(range,criteria)>=1 isse agr 1 se jyada bhi repetition h tb bhi highlight hoga
Ishu phir SE ek Baar dekhiye aap wo Question kya pucha gya tha..occurance 1 time ho to hi color krna hai na ..ek se jyada Hoga to wo to duplicate hi hai use kyu krna format..🙂M Happy ki aap analise karte Hain Questions ko aur different krne ki koshish krte hain..Good 👍❤️.
@@Innozant sir your question and solution was right according to your situation but agr range me vhi number 1 se jyada bar repeat hua ( like 3 times repeat,4 times repeat) then countif formula to sirf 1 time repeat ane pe hi cells ko colour krega na according to your condition. agr 2 ,3 4 ,i mean 1 se jyada bar repeat hora h number to mera wala formula shi hoga.kyoki apki condition ke according 1 se jyada bar repeat hone me countif formula 2,3,4 and so on answers dega aur apne apne =1 lgaya h condition me to colour hoga nhi us situation me. ab kya pta ki koi number range me kitni bar repeat hora h.mera solution meri condition ke according tha. ye mere kehne ka mtlb tha.🙏😊
Yes Ishu you are right in case of multiple duplicate value aur uspe formatting apply karna hai to,Jab bhi main interview cracker series me Questions Ka solution attempt krta hu aap koshish Kiya kro ki usse alag solution try Kiya kro aur mujhe btao ki iska solution Aise bhi ho skta hai jisse main ye Jan sakun ki aap logic Apne tareeke se laga pa re ho aur concept clear h apke jaisa ki aapne is Question me socha .👍❤️ Good morning.hv a nice day ahead. Happy Learning 🙏
Sir if we have 2group of numbers and both have dulipicate values and we want to know where tha duplicate values and also we want to match and romeve duplicate no from both of number groups
hi ak sheet make kar ni ha . ms execl par kuch is taraha say ha mujsay nai ho rahi ha S No particular 200gm /400 gm quty rate amount problems ya ha k items zida han jab invoice make karna hota ha to items list 70 ha or gm mai bhot dar ho jati ha koi asan sa trik ho
Hi Shweta ,Unable to provide link in RUclips comments due to RUclips policy ,You may find our contact details in our any any latest video intro or RUclips channel introduction.
Mind-blowing not only this I watched 4 lectures regarding advance tricks....
Thanks dear
This is the best approach for solving the all problems in few seconds , I love it sir ❤❤
Ur videos are truly amazing.....very helpful for working professionals
Thanks Ram
It was nice to clear that last tak video dekho and second thing sath sath excel pr try kro tabhi kuch fayda h 👍👍 Again amazing 😃
From Bangladesh
You are My BOSS in excel learning
Thanks Rasel ❤️🙏Happy learning❤️🙏
The way you explain the formula is amazing thank you so much and yes I've subscribed your channel☺
Thanks Vanisha , Really means a lot to me.Keep Learning And Keep Exploring👍❤️
Thanks i was looking for this duplicate formula I need it . I tried myself before but don't have solution now I do. So happy. Usually I was selecting all range .
Thanks dear
I am a real big fan of your sir.... Your all videos helps me.... Many ways.... I love your teaching style.... And also follows it.... When I am with my students.... I just remember your teaching style... And follow it... In my... Class... All my students... Are felling happy 🥰🥰🥰🥰🥰
Thanks Sarita..Really means a lot to me..Wow is it true ?❤🙏Hope these video are helpful and adds some values in your life..
Sir, you are great teacher
Thanks dear..Keep learning ❤️
Excellent sir
Thank you..
Thanks dear❤️🙏
it's too good video sir
please make a videos like that sir
Thanks dear..Sure will make more videos
you know you have a amazing talent
Kya baat h sir meri problem solve kar di apne last me
Thanks dear❤️
hi, I am frm Tamilnadu. Your videos are very useful . Have been learning both excel formulas, tricks, difficult tasks and Hindi Language. Your way of explaining step by step is exemplary. Thank-a- lot. Ravichandran. H
Thanks Ravichandran for your trust ,love and support.Have a wonderful career ahead.
Find duplicate wale formulae me aapne formula ko freez kaise kiya sir ?
I do not have word to praise you Sir
Thanks Mahima .Really means a lot to me dear.❤❤🙏🙏
Sir day by day u just increase your video clarity and this video is really helping me out enhance my skills too..
Good👍
No words.. Extraordinary
Very great trick
Sir Good after noon.
I m your subscriber and I want to know a complete tutorial on time calculation in ms excel. Plz share and upload a tutorial video. I will be thankful and greatful to u. Regards.
Amazing video
lajwab sir from gujranwala pakistan
Thanks dear Bilal
Thank u sir
I have lern lot of excel formula
from u
Thanks dear..Happy Learning 👍🙏
The video are superb sir
Boss you really champ....
Really means a lot to me dear
Great Sir❤❤
Thanks Jay
Bahut sundar sir
Very good
Sir jo bhi word likhe uska first letter automatic uppercase mein ho jaye....iska setting kaha milega sir plz reply 🙏
File-options me sayd advanced ke andar hoga .
Dear sir,
May i know, demand forecast training videos, please suggest if possible.i want to take demand forecast training
Please give a lecture on adding watermark and page layout
Ok .Aditya..👍🙏❤️
Can i get ur website sir and how get yr online classes. So, i can have duscussion for projects.
Search Innozant on Google ,You may find Innozant website for more information
Excellent
Good Morning Priyanka..Have a wonderful career ahead ❤️
Excellent 👌
Thanks ❤️👍
Sir how to add number with text......like...12pcs,10pcs,13psc,24pcs
Will make video for the same
10:21
sir i think apka ye conditional formatting ka formula always shi nhi hoga kyoki agr 1 se jyada duplicate hue to countif formula use highlight nhi krega
you should use= countif(range,criteria)>=1
isse agr 1 se jyada bhi repetition h tb bhi highlight hoga
Ishu phir SE ek Baar dekhiye aap wo Question kya pucha gya tha..occurance 1 time ho to hi color krna hai na ..ek se jyada Hoga to wo to duplicate hi hai use kyu krna format..🙂M Happy ki aap analise karte Hain Questions ko aur different krne ki koshish krte hain..Good 👍❤️.
@@Innozant
sir your question and solution was right according to your situation but agr range me vhi number 1 se jyada bar repeat hua ( like 3 times repeat,4 times repeat) then countif formula to sirf 1 time repeat ane pe hi cells ko colour krega na according to your condition.
agr 2 ,3 4 ,i mean 1 se jyada bar repeat hora h number to mera wala formula shi hoga.kyoki apki condition ke according 1 se jyada bar repeat hone me countif formula 2,3,4 and so on answers dega aur apne apne =1 lgaya h condition me to colour hoga nhi us situation me.
ab kya pta ki koi number range me kitni bar repeat hora h.mera solution meri condition ke according tha.
ye mere kehne ka mtlb tha.🙏😊
Yes Ishu you are right in case of multiple duplicate value aur uspe formatting apply karna hai to,Jab bhi main interview cracker series me Questions Ka solution attempt krta hu aap koshish Kiya kro ki usse alag solution try Kiya kro aur mujhe btao ki iska solution Aise bhi ho skta hai jisse main ye Jan sakun ki aap logic Apne tareeke se laga pa re ho aur concept clear h apke jaisa ki aapne is Question me socha .👍❤️
Good morning.hv a nice day ahead. Happy Learning 🙏
Your lecture is good, but plz also provide sheets as well.
Sheet are already there.
Kindly see the link in video description
heartly thanks
Awesome video, my question is related to this duplicate which I had mailed you plz help me
Bht saare mail aate hain dear..miss ho gya hoga..Ok will check it again
@@Innozant I understand sir...plz chk..not an issue
দারুন দারুন দারুন
Nice teaching sir
Thanks Madhuri..Recommend you to start your learning journey from Playlist Basic Excel onwards..step by step
Pl make regarding mailmerging.
Mail merge video available under ms word playlist
@@Innozant pl send link.
Pl guide make wages slip of 1000 people by help Mail merging.
Amazing sir..
Thanks dear
Sir 4th question m agr mutiple invoice no same h to ye kaam nahi kr raha kaise kiya jaaye sir
Duplicate vlookup use kren ..kya output chahte h
Sir if we have 2group of numbers and both have dulipicate values and we want to know where tha duplicate values and also we want to match and romeve duplicate no from both of number groups
hi
ak sheet make kar ni ha . ms execl par kuch is taraha say ha
mujsay nai ho rahi ha
S No particular 200gm /400 gm quty rate amount
problems ya ha k items zida han
jab invoice make karna hota ha to items list 70 ha
or gm mai bhot dar ho jati ha koi asan sa trik ho
Custom formatting se gm suffix kar skte hain
Superb
Thy👍❤️❤️🙏
As u replied inzannt team. Wesite sir???
Hi Shweta ,Unable to provide link in RUclips comments due to RUclips policy ,You may find our contact details in our any any latest video intro or RUclips channel introduction.
This video is unrated, it should be on toppppppp
♥️♥️♥️
Thanks sir❤🌹😊
Thanks ❤️🙏
sir can you please provide excel sheet link again because when i click on that link G drive show empty.
Dear direct mis master link is working fine..m working on video broken link..
Still issue shre your mail id or you may mail us for the same
Super bro
Thanks Swarna..God bless You..Happy learning ❤️👍
sir...आपको email करके, questions पुछ शकते है...??
@innozantofficial telegram id
Thinks sir
Amazing
Thanks Pradeep ji
Nice sir
Thnq sir
IE $ SIGHN KAISE A RAHA HAI ??
Sir meny 1300 logo ki list bnaye par glati say name or father's name 1 sath likh leya ab wo alag colom m kesy jaye ..?😭
Split kar lein ya to power query se yabusing formula
@@Innozant pls video bnaa k dkhaye.
👍👍👍
💞
Thanks ❤️
Excel ka ABCD sikha rahe ho bhaiya.
Ye safar Abcd se Z tak ka hai..keep learning
Sir, ये विडियो delet कर दें तो अच्छा है। क्यूं की इसमें आप कुछ खास करते हुए नही लगे
🌟🌟🌟🌟🌟
Sir have u any WhatsApp group???
No dear...telegram id is there