Sir esh video mai maja aagaya. Countif sai naya shikhnai ko mila. Step to step harchiz ko samja diya aapnai. Aapkai videos very knowledgeable. Aap humsabko etni achi videos bantai dhyanwaad. You are No.1 Tutor.
I decided that i bring complete transformation in my life through more studies, practice n will keep on practicing more advance excel n technical knowledge. It's promise to me. Great Rajiv Jee, i appreciate ur teaching. Thanks.
Hope you are doing practice on daily basis and learn step by step . Recommend you to Learn Basic Excel playlist ,then sorting ,Adv.Filter ,Whatif analysis then Lookup series as m uploading video in all playlist
Thanks Supriya, If you are beginner learner then I recommend you to start from Basic Excel Playlist 1st video onwards. Thanks for showing your interest in learning MIS.
Sir I have one data set in which I have to compute counts of sample result values (Non Numeric) from 5 different columns against one variable. but unable to find the solution? please guide
Sir just saw few lectures of your and really understand the concept..How to start from basic excel. Can you show me the path so that I will start from basic
Thanks Kiran,You may watch a Video Mis learning process (under career guide playlist) Start your learning journey from playlist Basic Excel-The learning begins followed by advanced Excel(step by step video playlist link available in our videos description)
Hi sir please clear this issue once.. for example if I'm calling my friend multiple times in a month or in a day for this I just want the unique for my latest call if day and time is also not there I want only unique with the help of countif formula without duplicate
Dear Sir, I have specific problem regarding BOM, e.g. abcd-1, abcd-2, abcd-3. As it is having first word before"-" common. Require counting method before "-" character. And it should count as one. In the BOM there are different type of item are there. It can be bdfg-1, bdfg-2, and so on.
Ek baat aapki bohat acchi lagi aur wo ha samjhane ka tarika. Agar ho sake to mera ek question solve kar dejye. Mujhe 2003version mey unique data kø låna ha but without duplicate + ascending order mey.
@@Innozant yes Sir, I am able to understand and learning new things daily basis. But sir I have no experience in Mis. Is it possible for me to get a job in Mis without experience because whenever I checked linkedin or other job portal they mostly required experienced person. But in the field of mis I am fresher. But my excel is ok-ok. Please advice.
There is no isssue either you are fresher or experienced,You may surely got opportunity if you are able to crack interview.Just make good command over Excel and then let know..will help you out
Hi..I have query. In my excel I have list of employees who done calls in last six months. Want to see how many has done each month with unique of names. Let's say if call is closed and month is Jun want to see how many employees worked on that month ..how to pull as like as distinct count in if formula
How to apply count formula with different sheet ... suppose agar ek sheet pe kuch unique remarks hai to second sheet pe multiple calling remarks hai to first sheet pe kaise apply karu ki mujhe ye pata chal jaye ki kis remark ke kitne count hai ...
Sir, I want to learn advance excel in detail , step by step and in a systematic way and achieve knowledge like your level...my progress is very slow learning in bits and pieces, do you also take the offline or online coaching. Please do reply.?
Hi Yusuf, Thanks for showing your interest in MIS learning. Yes we are running live/offline classes,You may contact us for more details.Kindly visit our website.
Sir I have to fetch average of large 2 number out of 3 cell. But condition is student may get absent in one or two exam and thus out of 3 cell one or two or even 3 cell may be marked as "ab" for being absent. So how to put average & large formula without converting text"ab" as "0" in separate cell and then fetch from there .Plz plz resolve and revert. Scenerio is like this Cell A1: ab Cell B1: 5 marks Cell C1: ab Cell D1: in this cell I want average of best two(out of A1, B1, C1)
Sir mera ek sawal hein Mujhe Saturday and Sunday count karna hein par, condition e hien ki, hamare pass sirf Star date hein , end date nahiiiii, par dono ka count ek sath karna hein Aap madat kar sakte hein
I have a List of Payments with Customer IDs in 2022 and 2023 date range. How to find count of Customer IDs those have made payment in 01/2022 to 12/2022 and also made in 2023. How to find count of Customer IDs those did not made payment in 01/2022 to 12/2022 and made payments in 2023. How to find count of Customer IDs those did not made payment in 2023 but made payments in 2022. do u have any suggestions
SIR I HAVE A QUERY THAT IS NAME IS PRESENT IN ROW WISE AND MONTH IS COLUMN WISE.IF I WANT TO SUM SUCH AS JAN TO MAR OF SOME GIVEN NAME WHAT FORMULA I HAVE TO APLLY.
Name: x Month from: jan Month to: mar Total:? Name rowwise hai or month column wise hai.ab mai koi Vi name dunga or month select korunga total dekha degi.nehi ho raha hai.
Hi Yadav Ji..simple nested if use krke kr skte hain..issue aa raha hai..to aap excel sheet bnake with query explanation @innozantofficial telegram id par share kariye
Sir, what is formula for counting unique value of different cell? for example In A1 cell has the text 'teacher' C1 cell has the text 'teacher' E1 Cell has the text 'teacher but In B1, D1 has not the text 'teacher'. how can we use formula for counting A1+C1+E1
"*" yeh NOT TEXT aise COUNTIF se karne par agar koyi BLANK CELL rehga wo bhi count mein aa jayega... Isliye cells with number dhoondne ke liye COUNT lagana behtar hoga
Ap k teach krny ka trika esa hy k lazy se lazy student b Sikh jae,kitna khush ho k or active ho k prhaty hen aap million of thanks 🙏🙏
Thanks dear for your valuable appreciation.Happy Learning ♥️
Wow Sir ji, Count A se Count ko minus karna maine kabhi socha hi nahi.. dhire dhire acha se samhe aara ha hai . Thanks a lot
Sir esh video mai maja aagaya. Countif sai naya shikhnai ko mila. Step to step harchiz ko samja diya aapnai. Aapkai videos very knowledgeable. Aap humsabko etni achi videos bantai dhyanwaad. You are No.1 Tutor.
Thanks Aswal sahab,I am always there for all of you..
Sir you are also a unique person with unique things.
Thanks Vishal Ji..keep learning and keep growing
Sir want to paste a text book in excel using each colom of the excel. I want to paste each word of the in each colom. please suggest something.
I decided that i bring complete transformation in my life through more studies, practice n will keep on practicing more advance excel n technical knowledge.
It's promise to me.
Great Rajiv Jee, i appreciate ur teaching.
Thanks.
Great ..HAVE A WONDERFUL CAREER AHEAD
Jo gyan kahi nahi mila ,wo is youtube par mila thank u gurudev
Keep learning
उस एक दीए की क्या खुब वाहवाही होती है।
सलाम हैं मेरा उन गुरुओं को,
सिर पे जिनके भविष्य को बदलने की जिम्मेवारी होती है।
👏👏👏👏Very great sir
Thanks Pooja ..God bless you dear🙏❤️
Sir jo aap effort kar rhe hai wo great hai. Great concept ! Bahut sikha maine aapse. Thank you sir.
every time i need help related to excel i just come here and every time i get solution thank you sir
Exquisitely taught sir ji..superb❤
Thanks sir, aap ka Tarika bahut behatar hai
THIS MAN DESERVES MORE SUBSRCIBER
Thanks dear.. Really means a lot to me
Very useful & informative video 👍
Great job sir very useful information 👍
Sir you deserve more than 1 like.
This is something out of the box I learn Today.
Thanks Anil for such a valuable feedback.. Really mean a lot to me.Will alway try to deliver awesome content always.🙏❤️
Samaj to bohott aache se aa gye guru ji
👍♥️
Very nice sir 👌
My problems solved, thanks sir
Thanks dear
Mast sir Ek dam 👌👌👌👌 very helpful video
Best excel teacher
Thanks Rajesh Ji❤️
Nice explanation Sir..Thanks for the helpful video 🙏🙏🙏
Thanku sir example mai name dalney ke liye aur countif ke liye.Again good night sir.😊
Thanks..Good night
M loving it guru ji ❤️
Great Sir, Big Thanks for practice questions 👍 and Thanks for being a good mentor and for guiding us on the right path🙏
Hope you are doing practice on daily basis and learn step by step .
Recommend you to Learn Basic Excel playlist ,then sorting ,Adv.Filter ,Whatif analysis then Lookup series as m uploading video in all playlist
@@Innozant yes sir I practice on a daily basis👍
Hello Sir,
How can be update occurance in access similar you have explained in excel like 1, 2, 3
Superb and always unique video sir and thanks that you have mentioned my name in this video
Thanks Khan Sahab ..Happy Learning .God bless you dear
Great concept learnt this morning ❤️❤️❤️❤️
Thank you Innozant
very usefull video sir,please share other advaced video 🙏
Great job it helps me alot
Bahut accha sir aap ka video
👍🏼Thank you for learning something different
Thanks Supriya, If you are beginner learner then I recommend you to start from Basic Excel Playlist 1st video onwards.
Thanks for showing your interest in learning MIS.
bahuttt badhya concept tha sir
Amaizing sir, salute you.
Thanks dear
Sir I have one data set in which I have to compute counts of sample result values (Non Numeric) from 5 different columns against one variable. but unable to find the solution? please guide
Hi sir, i have one question why did you not use * after real madrid sample?
As you use for “the”,”s” etc.
Sir I need a help ,
Have any option in excel if need subtotal of countif value ?
With you I feel I understand Hindi also 🙏
👍
sir last bala jo formula app lagaya wo samjh me nehni a rahi he why you are using ""&19000 instead of that direct we can use "19000" thats all
Yess
Hats off sir..........
Guru ji 10:35 ki timeing pr ap ne ik Question ka Formula lgaya hai (Countif+Countif) to is ka Ana 2 kyu aaya ???
Very useful, Sir!
How to do distinct count with count if s I. E multiple criteria and get distinct count using count ifs please explain
Wow Sir ji * is for text and nontext is .. thanks
Sir, I have more than five words in cell I need to find out two words of the cell by countif formula does it possible
Very good my friend.
Sir just saw few lectures of your and really understand the concept..How to start from basic excel. Can you show me the path so that I will start from basic
Thanks Kiran,You may watch a Video Mis learning process (under career guide playlist)
Start your learning journey from playlist Basic Excel-The learning begins followed by advanced Excel(step by step video playlist link available in our videos description)
sir.... Conditional formating se duplicate value high light hogi.. count to fir karna padega sir..
how to use counta function to autogenerate serial number when filter used ?
Hi sir please clear this issue once.. for example if I'm calling my friend multiple times in a month or in a day for this I just want the unique for my latest call if day and time is also not there I want only unique with the help of countif formula without duplicate
Sir please give us a favour that how can we expert in applying formulas properly because it's very difficult to remember them, we often forget it.
Sir jo last option hai not equal to 1900, "" iska matlab sirf 'Not' hota hai na to 'equal to' lagana jaruri nahi hai?.
Hi sir, less than and equal to , what criteria will i use?
Less than 4 and equal to?
Sir agar kisi list me koi naam repeated hai aur hame pata karna hai wo naam koun koun se row number me hai to formulae kya lagega
Dear Sir, I have specific problem regarding BOM, e.g. abcd-1, abcd-2, abcd-3. As it is having first word before"-" common. Require counting method before "-" character. And it should count as one.
In the BOM there are different type of item are there. It can be bdfg-1, bdfg-2, and so on.
sir what is formula for counting unique value of different cell?
Countif lgakr text and number ek sath utha sakte???
How to count the cells from a range of where the cells having more than (for example) 6 digits in one cell....pls help
So nice Sir 👍
thanks sanoj ji
Most useful
Thanks dear❤️❤️
Very nice sir
Thanks Raveeesh Ji
Ek baat aapki bohat acchi lagi aur wo ha samjhane ka tarika. Agar ho sake to mera ek question solve kar dejye.
Mujhe 2003version mey unique data kø låna ha but without duplicate + ascending order mey.
Thanks..Haan kr skete hain.sheeet share kriye..will guide you
@@Innozant email id bhejye mei send karta hu
Sir how to count no of cell where time is present!!!! Such as 7:30am, 8:40pm!!!!
Is it possible to match condition (Header match) inside countifs.
The moment we change header count value should be changed
Share excel sheet will see dear
I got the formula. Thanks for the response
Sir, you are awesome.
Thanks Hemant,Hope you may able to understand the topic and enhance your skills bon regular basis.
@@Innozant yes Sir, I am able to understand and learning new things daily basis. But sir I have no experience in Mis. Is it possible for me to get a job in Mis without experience because whenever I checked linkedin or other job portal they mostly required experienced person. But in the field of mis I am fresher. But my excel is ok-ok. Please advice.
There is no isssue either you are fresher or experienced,You may surely got opportunity if you are able to crack interview.Just make good command over Excel and then let know..will help you out
@@Innozant thanks you sir for your advice. I will try much harder to be an expert.
Good ...learn step by step..from basic excel playlist video..then sorting..filter..what if analysis .. Lookup series ..
Hi..I have query. In my excel I have list of employees who done calls in last six months. Want to see how many has done each month with unique of names.
Let's say if call is closed and month is Jun want to see how many employees worked on that month ..how to pull as like as distinct count in if formula
Share your excel sheet .Will guide you for the same .
@@Innozant will share
Ok if I have the dates from 1st to 30th October but here I want the latest call unique without duplicate with the help of countif formula
Sir apne Esme tex or number dono ke bare me btaya Lekin Esme ek row me number or tex combine h uske bare me bhi toda bta dete
Muje dashboard ek sheet pe amend ho aur dosre sheet par update ho thanks sir
nice vedio . but sir please give the saprate excel link for download purpose
Link is broken ..we are working on it..will update soon
How to apply count formula with different sheet ... suppose agar ek sheet pe kuch unique remarks hai to second sheet pe multiple calling remarks hai to first sheet pe kaise apply karu ki mujhe ye pata chal jaye ki kis remark ke kitne count hai ...
Sir, I want to learn advance excel in detail , step by step and in a systematic way and achieve knowledge like your level...my progress is very slow learning in bits and pieces, do you also take the offline or online coaching. Please do reply.?
Hi Yusuf, Thanks for showing your interest in MIS learning.
Yes we are running live/offline classes,You may contact us for more details.Kindly visit our website.
Sir I have to fetch average of large 2 number out of 3 cell. But condition is student may get absent in one or two exam and thus out of 3 cell one or two or even 3 cell may be marked as "ab" for being absent. So how to put average & large formula without converting text"ab" as "0" in separate cell and then fetch from there .Plz plz resolve and revert.
Scenerio is like this
Cell A1: ab
Cell B1: 5 marks
Cell C1: ab
Cell D1: in this cell I want average of best two(out of A1, B1, C1)
Thanks sir
Sir, please make a video in which all types of spaces remove by only one formula in excel.
Ok..noted
🙏👍
how to select the range if the cells are not in sequence
Excellent 👌👌
i HAVE A FEED BACK DATA BASE, AND I WANT TO REPORT PREPARE FROM THE DATA, PLZ. HELP ME
Superb....!!
Thanks Ajinkya.Good Night
Sir mera ek sawal hein
Mujhe Saturday and Sunday count karna hein par, condition e hien ki, hamare pass sirf Star date hein , end date nahiiiii, par dono ka count ek sath karna hein
Aap madat kar sakte hein
Sir, if we use countif(range,"*") it counts spaces also.
Aditi < >* means jo text nhi ho to number count krega na.
yes Aditi if any cell contains spaces are considered as text, so this formula is counting those cell as well.
How to use countifs in countifs & sumifs in one Excel sheet to another Excel sheet
Dear Sir, we want occurrence based on category
Sir ji ye excel sheet kaha par save hai, drive ke path pr nahi mil rahe hai.kindly help
Kisi bhi video ke description me jaake dekhiye ek assignment master folder download link hai wahan saare hi example mil jayenge playlist wise
Useful video sir.. .
Can you please make a video on application of correlation & regression in excel ?
Yes will make correlation covariation standard deviation and others associted topic soon
Sir unique name hi lane ke liye esme ham if function lga skte h kya? Kyoki if function se jiski value 1 hogi vo hi aayega nhi to "") kar denge
=sumproduct (1/countif(A1:A10,A1:A10))
Use for uniquebcount from a range
Thanks
I have a List of Payments with Customer IDs in 2022 and 2023 date range.
How to find count of Customer IDs those have made payment in 01/2022 to 12/2022 and also made in 2023.
How to find count of Customer IDs those did not made payment in 01/2022 to 12/2022 and made payments in 2023.
How to find count of Customer IDs those did not made payment in 2023 but made payments in 2022.
do u have any suggestions
Could you help me with VBA coding of of countif
Yes VBA series starts soon .meanwhile if you have any query you may ask
@@Innozant I want VBA coding of countif formula
Same formula in VBA coding
Great Sir 👍
Could help me to count unique, not duplicate data?
=sumproduct (1/countif(A1:A10,A1:A10))
Use for uniquebcount from a range
Sir ye wale video kha pe mele ga
SIR I HAVE A QUERY THAT IS NAME IS PRESENT IN ROW WISE AND MONTH IS COLUMN WISE.IF I WANT TO SUM SUCH AS JAN TO MAR OF SOME GIVEN NAME WHAT FORMULA I HAVE TO APLLY.
Formula ko automatic se hatake manual kar lijiye pehle phir jaise chahen circular reference sum ho jayega
Name: x
Month from: jan
Month to: mar
Total:?
Name rowwise hai or month column wise hai.ab mai koi Vi name dunga or month select korunga total dekha degi.nehi ho raha hai.
I have date, Unit and analyst name and I need unit count daily, Weekly and Monthly
Invoice
Sir, please solve my problem.
Qut- Rate- Disc%- Tax%- Net Amount
3 - 50 - 15% - 1%+ - 128.77
Hello sir
Please help me to count the students ,who get less than 70 and more than 50 in all subjects
Hi Yadav Ji..simple nested if use krke kr skte hain..issue aa raha hai..to aap excel sheet bnake with query explanation @innozantofficial telegram id par share kariye
excellent
thanks
hello sir i want your email to share excel sheet for one formula for my class result analysis..please
@innozantofficial telegram id
Sir, what is formula for counting unique value of different cell? for example In A1 cell has the text 'teacher' C1 cell has the text 'teacher' E1 Cell has the text 'teacher but In B1, D1 has not the text 'teacher'. how can we use formula for counting A1+C1+E1
He only knows how to bring results. Don't know how to explain in detail. He's trying to be over smart.
"*" yeh NOT TEXT aise COUNTIF se karne par agar koyi BLANK CELL rehga wo bhi count mein aa jayega... Isliye cells with number dhoondne ke liye COUNT lagana behtar hoga
GOOD
SIR ELECTION DUTY CARD KAISE BANAYE MS EXCEL SE PLESE TELL ME
Hi sir apka Excel ka class lete hai kya apka location konsa hai
Yes..New Ashok Nagar ,Delhi
Live aur offline dono class available hain.Aap Join kar sakte hain
@@Innozant mumbai hai class apka Mera location mumbai hai
@@snehalsanap1507 Live class join kar lein aap
@@Innozant Excel mai index match vlookup and poichat table sikhana hai konsa class lagana hoga Excel ke liye
How to get maximum duplicate occurrence without manual counting ?
Using count if ..