Thanks for making Excel cheap. I am working on a project and got stucked . Need a one on one tutelage. I am ready to commit myself financially. How do i get starting with you? Would be glad to read from you. Respectfully.
HELLO SIR ,THANK YOU FOR MAKING EXCEL FUN !!! MAY I REQUEST YOU DO VIDEO ON HOW TO SUM UP DATA FROM MULTIPLE WORKSHEETS using Sumproduct, sumif and indirect formulars thank you
Turned out very helpful for me but I've one query suppose i wanna count the values lying in a data array, in a specific given range how do i do that? Please reply and guide if possible for you🥺
Doubt- Oce we use "countblank" function on a large dataset and found that there are suppose 3 cells which are empty. How can I go directly to those cells which it has counted just to verify that I have left them blank knowingly or some data got deleted by mistake? It'll be very useful if you can answer this doubt.
Sir, can you help me with one query? I have once date (08th Aug'22) and I need to know what will be the future date after specific number of days (7 days) also taking weekends into consideration.
hello sir, i have a question, whenever i write after the select range like you wrote Apple you have got the answer but i get always 0. why? i can not write in any formula i have to select the cell
Hello sir now i have one Q for you help: i have date in excel is 1- A,B,A,C,G 2- A,B,A,C,G 3- A,A,C,G 4- A,B,C,G i want count 1to4 have A how much ? please help me too
I have a spreadsheet where I want to keep track of a number in a lot of cells and how many times the number appears. Also When the number appears i want it to go back to 0 and start the count again until the number pops back up. Can excel do that?
Hi bro I have data date wise sales and purchase I need you are support in excel when IAM enter specific any date I need that date how many sales and purchase happen I require counts like I use today date I required 100 sales and purchase 50 like Wich formula I need to use
Sir I like your video too much . Sir I have one problem. I have 5 value like, 15,20, 8,9,5. In this I want to count value which less than 10 and greater than 15 . How count formula is apply
Hello Sir! How can I count No. of Present Mark in a week (From Monday to Saturday) on weekly basis for the whole month using formula and not using VBA.
Can someone solve this please? If I Enter 500 How to enter formula to display. 30. 70. 100. 100 100 row wise using IF Formula 1-30 ---. 30 31-100 --- 70 101-200--- 100 201-300--- 100 301-400--- 100 Above 400
![ROSÉ (로제) - number one girl [더 시즌즈-이영지의 레인보우] | KBS 241129 방송](http://i.ytimg.com/vi/A9oByH9Ci24/mqdefault.jpg)
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Profound way of teaching...great Sir
Thanks so much for the tutorial and am always learning from your videos
Your explanation is extremely superb. In a simple way you make learners understand.
quick,easy,not wasting time....u r toooooooooooooooo gud
greattt explanation,so much patience , very helpful video
Thanks for this video it was very helpful learn so many things in excel thanks team for this wonderful effort
Fluent way of answering..... ♥️🙏
provide those excel sheet so that people can practice at the same time ....
you making thing quite simple, thanks...
S A p chennai , Your Coaching is Excellent
Feels like back to school.
Thank you so much sir for all vedios this helps me understanding so easily i m learning english speaking also 😊
Brilliant work 👏🏽
VERY HELPFUL
THE TEACHER IS AWESOME
I like your method of teaching. super
Excellent video bud helped me quote alot for my CAT exam
thank you sir for explaining in english
Very Clearly Explained..
Thanks so so musch, your videos have help me alot to understand excel , can you please make a vedio of PAYE formula in excel
You are great at explaining. Thanks so much!
Thank you ! Very much. It 's useful for me
Thank you brother, it was easy explaination
Thank you you are legend 🎉
Amazingly taught sir
Hi Bhai.The way u explain things is amazing in any concept. I always refer your video relating to excel and word tips when ever i get doubt.
thanks
Sir Your video is very simple to understand your voice is very clear
Thank you🌹🌹 keep it up.. 😘
U r rocking Sir 🙏🙏
THANK YOU SO MUCH REALLY SO MUCH HELPFUL WITH A SIMPLE TECHNIC.
THANK YOU SIMPLE TO THE POINT
bro your explanation was awesome!
Thanks for making Excel cheap. I am working on a project and got stucked . Need a one on one tutelage. I am ready to commit myself financially. How do i get starting with you? Would be glad to read from you. Respectfully.
thank you sir.....helped me alot
Best teach
easily explained
Supper explanation
HELLO SIR ,THANK YOU FOR MAKING EXCEL FUN !!!
MAY I REQUEST YOU DO VIDEO ON HOW TO SUM UP DATA FROM MULTIPLE WORKSHEETS using Sumproduct, sumif and indirect formulars
thank you
Turned out very helpful for me but I've one query suppose i wanna count the values lying in a data array, in a specific given range how do i do that? Please reply and guide if possible for you🥺
thank you sir 🙂🙂
Good explanation
the equation formula on the right, how do you write it in excel? please, explain. thanks
how did you got the formulas of permit and comb
Hi please make video on countifs
Thank u sir
Nice & Crisp
How can we show formula only in specified cells but not in every cell
Thank you very much sir
But how can i manege name of students by ( a. B. C ) in thier names
if you have tim plz show me this
Thank you😊❤😊❤😊
Super sir. Tq so much
Any app? Of tutorial point
In count if why we right [apple] why we can never select it.
Hi Sir,
In the function of consolidate, we can choose:'count', 'countnumber'. What is the difference?
Thank you.
Question: for countif, what if I want to know how many repetitions of *32* apples there are, not just apples?
Hi, what if any one of the word has space among rest of the same word. How to use trim and use countif
Doubt- Oce we use "countblank" function on a large dataset and found that there are suppose 3 cells which are empty. How can I go directly to those cells which it has counted just to verify that I have left them blank knowingly or some data got deleted by mistake?
It'll be very useful if you can answer this doubt.
Using Go to special feature you can directly jump to blank cells. Press F5 key to open Go to dialog box and select Go to Special.
I come to your videos you are awsm..but some times i feel like i cant concentrate more coz you are in hurry.
Hello Sir, can you please provide the formula to find number of characters or digits are there in a particular cell.
Suoer sir
Sir, can you help me with one query? I have once date (08th Aug'22) and I need to know what will be the future date after specific number of days (7 days) also taking weekends into consideration.
Thanks
Well
HI sir
i want to know the number of apples every day - what is the formula ?
can we use COUNTIFS() function Using Today()
hello sir, i have a question, whenever i write after the select range like you wrote Apple you have got the answer but i get always 0. why? i can not write in any formula i have to select the cell
in this video the last two formulas not understanding, please clear my doubt. how can i do
How to ONLY count positive OR negative numbers in selected sells?
Thank You
How can we write permutation and combination formulas in excel or you copied it from somewhere else ?
PERMUT and COMBIN are the inbuilt functions in excel.
Insert equation
Thank u
Sir COUNTIF se me jan feb march vala example try kar raha hu pn meta answer Zero hi show kar raha he
Same here
Countif me apples wala bhi kr rha hun to answer zero aa rha hai. Please help 🙏
Where can I get this dataset?
I need basic excel to advance excel fro youtube
Hello sir
now i have one Q for you help: i have date in excel is
1- A,B,A,C,G
2- A,B,A,C,G
3- A,A,C,G
4- A,B,C,G
i want count 1to4 have A how much ? please help me too
I have a spreadsheet where I want to keep track of a number in a lot of cells and how many times the number appears. Also When the number appears i want it to go back to 0 and start the count again until the number pops back up. Can excel do that?
Thanks bro
Hi bro I have data date wise sales and purchase I need you are support in excel when IAM enter specific any date I need that date how many sales and purchase happen I require counts like I use today date I required 100 sales and purchase 50 like Wich formula I need to use
Sir I like your video too much .
Sir I have one problem.
I have 5 value like, 15,20, 8,9,5.
In this I want to count value which less than 10 and greater than 15 .
How count formula is apply
Please reply
Try using countif function
=COUNTIF(A3:F6,">10")
You will get the answer
Hi
I am getting a error for the following
=offset($A$2,,,counta(A:A)-1,1)
Please suggest
Hello Sir!
How can I count No. of Present Mark in a week (From Monday to Saturday) on weekly basis for the whole month using formula and not using VBA.
Please sir, I don't get the formula
Sir yeh formula nhi lg rha mere excel me #value aarha hai repeat me
HOW TO SUM , MULTI NAME WITH MULTI FIGURE ??
=50+70+80+90+40+30+60+40+30+20Now what do you think about the numbers here?Now how to count the numbers here
Sir tell me countifs function
Can someone solve this please?
If I Enter 500
How to enter formula to display. 30. 70. 100. 100 100 row wise using IF Formula
1-30 ---. 30
31-100 --- 70
101-200--- 100
201-300--- 100
301-400--- 100
Above 400
i love you
Sir can you explain little bit hindi
didn't understand
how we can contact you
Thank you sir
didn't understand