Hi Dilip Sir, I am glad to inform you that your video is too effective and simple to understand its logic of functions and formulas. I don't have word to express myself about your youtube tutorials. i have learnt a lot in excel and on daily basis, i try to learn and practice more. Thank you so much to prepare such kind of important and useful videos who wants to learn through youtube channel. I also inform you that in my initial time, i had subscribed your channel.
Sir I have. I word to describe your teaching methods but I'm happy to have you my excel teacher who teach me excel very easy and deeply way which no one can do ❤️🙏sir god bless you 👍
Holy krap ! Just got done watching 3 other videos on this topic trying to do what you say at 3:30, but watching those videos (English speakers, and I only understand English) well none of those videos explained how to do what I needed. Just watched this video and despite him speaking a language I can't decipher, I was able to understand how to do what I needed to do in EXCEL (again, 3:30 of video). This dude is awesome....excellent visuals.
I have seen so many tutorials in RUclips, but your way of explaining the logic and why it is happening is just WOW...Lots and lots of applause to you for making such great and true learning videos. You are truly doing good to the overall IT Industry and social well being. Social well being because, positivity comes from knowledge and you are sharing your knowledge which is being converted into positivity. Thanks a lot...Please continue this good work...
Before subscribed your channel sir I saw many of you tube channel but didn't get kind of content what you deliver for your learner how easily and deeply you described concept is fantastic sir 🙏I learnt lot of tricks and basic of excel for last one month which is unbelievable for me as bigners 🙏 sir
नमस्ते सर जी, सर आपने Sumproduct and CountIF with Unique Values बहुत ही डिटेल मैं और अच्छे से समझाया | मुझे आज नई चीज़ सीखने को मिली | आपका बहुत बहुत धन्यवाद सर जी |
your way of explanation if just amazing sir. if you have any video about extracting unique list from duplicate items with using formula, please share that video with me. i will.be very thankful to you for this ❤️
Brother thanks for details explanation video, really it's awesome video. I have a request and for the solution. Same I need unique count with multiple criteria and one criteria from different columns
excel banane walo ko vi itna pata nehi hoga ki excel formula ko itna alag tarikha se cherkhani ki ja sakti hey. sir app jab formula likhte ho mere kheyal formula vi confused ho jati hongi ki karna keya tha or wo kar keya raha hey. hahhahahahhahahah. nice sir . very nice vdo.
Hahaha..Really means a lot to me..Aapke ye word mere liye kiss gift se kam nhi hai Srikanta.Aaapko humesha kuch better aur alaga seekhane ki koshish hogi meri
ek query hai sir, two column hai ek work ka, jisme ek date hai aur ek name, main chahata hu ki kisi ek ke naam se count karu woh kitne din woh kaam kiya (without pivot table). please help on this.
Thank you for your lessons...I have been using subtotal very often... mostly on top of headers...so whenever any particular name of company/person is selected using simple filter..subtotal automatically updates figures right on top...but that doesn't work when I want to see unique count of any particular field associated to that company or person selected through filter....I have applied combination of sumproduct and cuntif when filter isn't applied it gives me correct unique count...but when any particular company etc. Is selected..unique count remains same...because may be the range given in formula is static and not dynamic.. basically I want to see unique count being updated the way total is updated using subtotal... whenever filter is applied.....hope I was able to convey my query..
Great concept sir, Thanks, Kindly advice If I want to sum of "Salary" column for only unique occurrence. as this case, 4 kind of different unique occurrence then How to sum of salary column only for this occurrence
First of all thank you so much for making myself confident on excel day by day. Total credit goes to you only my dear brother... Pls suggest that how we can use this formula along with V-lookup
Mene kal ek mis ka interview join Kiya or mere se technical Excel ka question pucha gaya ki jisme customar name or customer ID di huyi thi or customar I'd common thi i reviewed ne bola ki unique I'd k aadhar par customer ki margin pickup karni h wo bhi without pivot table k please reply
Which formula for perticular item or party in different date comes and we have to count how many times that item/party in less than 7 Days and more than 7 Days in Big data.
Good morning Sir Thank u sabhi videos k liye Main chahta hu apke is data me se dusri sheet me main employee I'd ek bar dalu to uske samne uski teeno salary aa jaye with formulas
very useful video sir, for exa- column A has invoice no , column B has customer ID now I want to count the invoices of each customer ? it can be done using countifs range is customer id as it counts in that column how many Cus id are there as same invoice no, but if in column A some rows remains no invoice no column B row has Cus id the result will b wrong as it counts Cus id but in that specific row has no invoice no (for some reason say payment given for previous invoice) Pls advise how to find it
Sir, Mere pas aysa hi ekta data he lekin sir usme employee visit many customer in a day some Times employee visit same customer two time in a day, mujhe duplicket valu nikal he using same employee visit same customer using function. Please help
Sir दो batch example (batch 1 and batch 2 ) ki same date na ho vertical me ye kese kare...I am facing big problem pls help me sir, how can I show data to you sir.
Sir me bhi study kar Raha hun excel ki me mis Executive hun me bhi apni video dalna chahta hun sir so please suggest me I am continuing watching your videos from long time
Achi Baat hai,First of All Apna Vision plan kijiye .Aur uspe kaam kijiye..Jo kaam start karen tbhi karen jab usme passion ho aur aap usko enjoy karte hon..To bahut acha kar sakte hain life me.
Thanks Pari, Recommend you to start your learning journey from playlist Basic excel step by step in sequence followed with MIS interview cracker.Have a wonderful career ahead❤️❤️❤️👍
Bikul iferror use kar lijiye ya..if aur uske inside iserror bhi kar sakte hain..better rhega koi bhi formula lagayen to uske bahar iferror jarur lagayen.
Sir if I want to count Mondays or any other day present/absent only in an attendance sheet. How can I do it in excel. Kindly consider this urgent. Make a video on this topic
Hi Dilip Sir,
I am glad to inform you that your video is too effective and simple to understand its logic of functions and formulas. I don't have word to express myself about your youtube tutorials. i have learnt a lot in excel and on daily basis, i try to learn and practice more. Thank you so much to prepare such kind of important and useful videos who wants to learn through youtube channel. I also inform you that in my initial time, i had subscribed your channel.
Thanks Rajan for your valuable appreciation.Really means a lof to me.Keep Learning & Keep Exploring👍
...aapka dil bohot bada hai bhai....free main itne knowledge sab ko dete ho....🙏...God bless....!!!
You are man of integrity...!!!
Thanks dear...Keep Learning ❤️
Sir I have. I word to describe your teaching methods but I'm happy to have you my excel teacher who teach me excel very easy and deeply way which no one can do ❤️🙏sir god bless you 👍
Thanks Pawan for your valuable appreciation dear.Really means a lot to me
Best method to find count unique values.......best teacher ever.....
Thanks Ranvir for yout valuable appreciation ❤️❤️🙏🙏
Holy krap ! Just got done watching 3 other videos on this topic trying to do what you say at 3:30, but watching those videos (English speakers, and I only understand English) well none of those videos explained how to do what I needed. Just watched this video and despite him speaking a language I can't decipher, I was able to understand how to do what I needed to do in EXCEL (again, 3:30 of video). This dude is awesome....excellent visuals.
I have seen so many tutorials in RUclips, but your way of explaining the logic and why it is happening is just WOW...Lots and lots of applause to you for making such great and true learning videos. You are truly doing good to the overall IT Industry and social well being. Social well being because, positivity comes from knowledge and you are sharing your knowledge which is being converted into positivity. Thanks a lot...Please continue this good work...
M speechless..Thanks Chowdhury sahab..Hope these video tutorials will adds some values in your life..Thanks for being part of Innozant family .
Before subscribed your channel sir I saw many of you tube channel but didn't get kind of content what you deliver for your learner how easily and deeply you described concept is fantastic sir 🙏I learnt lot of tricks and basic of excel for last one month which is unbelievable for me as bigners 🙏 sir
Thanks Pawana ji.Learn ..enhance your skills on regular basis..❤️
नमस्ते सर जी, सर आपने Sumproduct and CountIF with Unique Values बहुत ही डिटेल मैं और अच्छे से समझाया | मुझे आज नई चीज़ सीखने को मिली | आपका बहुत बहुत धन्यवाद सर जी |
Thanks Sandeep Ji..Aaj Live Interview of MIS EXECUTIVE video aane wala hai..must watch
Way of explanation is excellent, thanks for sharing your vedios.
My thirst for learning going to be increased day by day as I continue to watch your videos. This is quality of really guru🇵🇰🇵🇰❤️♥️
Thanks Raja Rizwan..Really means a lot to me dear..Happy learning
Best indian excel guide!!🔥🔥
Thanks dear
Nice video.. i am looking this formula from last 1 week....
Thanks.
Amazing, I tried so many things but failed. This formula worked for me and I got the Solution. Thank You so Much Sir 🙏
Thanks dear ❤ Nitish for this valuable comment ..God bless you ..Happy learning
Hi Dilip Sir,
Will you please tell me the process to extract uncommon record set from different sheet or different workbook?
Thank you Dilip sir Maa kali or apke sahyog se mujhe kaafi Kuch shikhne ko mila apne mujhe creative bna diya dhanyavaad gurujii jai maa kali ❤
YOU ARE BRILLIANT!
Respected Dilip Sir,
Your video is too good to learn Excel. Sir I have a problem, how can I get unique man power in sum count between time.
Sir, excellent video, aapne bahut easy kar diya
Thanks Vikram Ji
Mind-blowing sir
I have a question how to count of only capital letter Text in column
Ye series sabse alag hai sir. Baar bar dekhta hu mai
Good Shrikant..Aap revision mode on kar rakhe hain aapna..Keep growing
your way of explanation if just amazing sir.
if you have any video about extracting unique list from duplicate items with using formula, please share that video with me.
i will.be very thankful to you for this ❤️
You are genius sir ,Thank you for this video😊😊
Thanks Ankita.. Really means a lot to me dear ❤️👍
sir app gyan ka sagar ho 🥰👌👌👌👌
Thanks Ankit❤️😊
THANKS SIR!!!!!!
Omg thank you for sharing this wonderful video I'm searching this method from past 2 weeks
Thanks Arman...Happy learning dear..God bless you..Happy learning
Your way of teaching is quite good... Keep doing good work for learners...🙏
Thanks Vishwadeep ji..Happy learning
Sir your excel video mindblowing and encouraged to all excel learners.Good night
Thanks Satish ,Apke aise comments really mujhe motivate karta hai..acha. Sikhaun aplogon ko..aur aap life me aage badhen
Brother thanks for details explanation video, really it's awesome video. I have a request and for the solution. Same I need unique count with multiple criteria and one criteria from different columns
excel banane walo ko vi itna pata nehi hoga ki excel formula ko itna alag tarikha se cherkhani ki ja sakti hey. sir app jab formula likhte ho mere kheyal formula vi confused ho jati hongi ki karna keya tha or wo kar keya raha hey. hahhahahahhahahah. nice sir . very nice vdo.
Hahaha..Really means a lot to me..Aapke ye word mere liye kiss gift se kam nhi hai Srikanta.Aaapko humesha kuch better aur alaga seekhane ki koshish hogi meri
ek query hai sir, two column hai ek work ka, jisme ek date hai aur ek name, main chahata hu ki kisi ek ke naam se count karu woh kitne din woh kaam kiya (without pivot table). please help on this.
Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence
Can this be done with countifs
Thank you for your lessons...I have been using subtotal very often... mostly on top of headers...so whenever any particular name of company/person is selected using simple filter..subtotal automatically updates figures right on top...but that doesn't work when I want to see unique count of any particular field associated to that company or person selected through filter....I have applied combination of sumproduct and cuntif when filter isn't applied it gives me correct unique count...but when any particular company etc. Is selected..unique count remains same...because may be the range given in formula is static and not dynamic.. basically I want to see unique count being updated the way total is updated using subtotal... whenever filter is applied.....hope I was able to convey my query..
Great concept sir, Thanks, Kindly advice If I want to sum of "Salary" column for only unique occurrence. as this case, 4 kind of different unique occurrence then How to sum of salary column only for this occurrence
Sir ji apka vedio or smjane ka trika bhut acha h ase hi vedio bnate rhna
Thanks dear..Humesha milta rahega videos seekhne ko..
I am moving out of my comfort zone. There is still a lot to learn. Thanks Sir.
Best of luck my dear friend..Go ahead,Have a wonderful career.
In same case if one more value like permanent employee or contract employee are use so how can count only contract employee or permanent employee
First of all thank you so much for making myself confident on excel day by day. Total credit goes to you only my dear brother... Pls suggest that how we can use this formula along with V-lookup
Thanks 🙏❤️
Searching for this type of formula..
Thanks
❤️👍
So much respect for you Sir. The way you explained is too good.🙏
Sir how can I count unique value based on condition?
Thanks Brijesh ji...Aap series dekhte rhiye bht saare sawal ke jawan apko khud ba khud mil rahe honge
Thanks for videos sirG
Thanks dear ❤️
Amazing
Thanks for this
Sir unique count ka multiple sheet main bhi batao ek saath without unique and vstack ke
Thankyou very much!
Sir, How to count Unique with multiple criteria like employee id wise channel partners...
Great way of explaining the things. Really nice 👌👌👌👌👌
Thanks Vikrant Ji.Happy learning
Very well explained...
Thanks Shreya..Keep Learning ..Keep exploring
Macro with pivot table ke saath kese banayege. Video banaye.
bahut help hua sir
Wow. Me bhi excel me job karta hu but esa logic me kabhi nahi soch skta
👍
Good teaching
really good explanation
Thanks Charvie.We welcome you to experience the taste of success with Innozant -Seed of success. ❤️❤️❤️
Sir can we find the last nth match value?
Mene kal ek mis ka interview join Kiya or mere se technical Excel ka question pucha gaya ki jisme customar name or customer ID di huyi thi or customar I'd common thi i reviewed ne bola ki unique I'd k aadhar par customer ki margin pickup karni h wo bhi without pivot table k please reply
Thanks you sir for explain such important topics.
Thanks Hemant,Happy Learning
Excellent!!!!
Intelligent Sir
Thanks dear❤️
Excellent sir
Thanks dear
Which formula for perticular item or party in different date comes and we have to count how many times that item/party in less than 7 Days and more than 7 Days in Big data.
Excellent 👌 sir.. thanks for video.
Thanks Sandeep,Have a wonderful day.
Happy Learning
Sir agar dono coloum me se ya 3 coloum me se unique count nikalna hai to kya formula hoga. Please suggest me
Distinct count bataya hua hai detail me maine ..pls check Excel maharaj playlist
excellent sir..
Thanks Sridhar❤🙏
Sir agar hmaari range pure column ki hai A:A h tab kya karrnge.
insted of blank if few cells contain "-", then how to delete count of "-"
Dive Deep Thats Innozant
Thanks
Sir. Ek video esi bnau jisme pivot k through unique value count sum kr ske plz..
Sir yadi hame date wise unique value nakalana ho to kaise mikale agar hamare pass ek sal ka Data ho
Good morning Sir
Thank u sabhi videos k liye
Main chahta hu apke is data me se dusri sheet me main employee I'd ek bar dalu to uske samne uski teeno salary aa jaye with formulas
very useful video sir, for exa- column A has invoice no , column B has customer ID now I want to count the invoices of each customer ? it can be done using countifs range is customer id as it counts in that column how many Cus id are there as same invoice no, but if in column A some rows remains no invoice no column B row has Cus id the result will b wrong
as it counts Cus id but in that specific row has no invoice no (for some reason say payment given for previous invoice)
Pls advise how to find it
Rqmzein Sahab it's better you may share your query excel sheet on @innozantofficial telegram.will See your query and try this make time for the same
Very nice sir.
Thanks Bhoopi
Sir how to get distinct count by formula ??
Sir,
Mere pas aysa hi ekta data he lekin sir usme employee visit many customer in a day some Times employee visit same customer two time in a day, mujhe duplicket valu nikal he using same employee visit same customer using function.
Please help
How count days between two dates of list of items pls
Thanks 👍
If the formula need to be done on a new worksheet..will that work? Am looking for formula to count unique values by country level means a lot of data
Want to know the count with duplicate and without duplicate values by country level (do we need a specific criteria from each sheet of country?)
Sir दो batch example (batch 1 and batch 2 ) ki same date na ho vertical me ye kese kare...I am facing big problem pls help me sir, how can I show data to you sir.
can you tell me how to list unique name from 2 name list.
in this video you have shown how to find unique name count .
Bahot bahatreen. Sabhi formulas ka aapne postmortem kar rakha he
😊👍
This use with filter
kindly help
Please help me unique count but only visible cell
Sir me bhi study kar Raha hun excel ki me mis Executive hun me bhi apni video dalna chahta hun sir so please suggest me I am continuing watching your videos from long time
Achi Baat hai,First of All Apna Vision plan kijiye .Aur uspe kaam kijiye..Jo kaam start karen tbhi karen jab usme passion ho aur aap usko enjoy karte hon..To bahut acha kar sakte hain life me.
you are really great sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
thanks dear❤❤
Agar ek data dusri sheet pr same chahiye pr unique sirf headers hai or koi id ya aisa kuchh unique nhi hai to kaise lekr ayenge..
HiI have more than 50 Lakhs Products IDs and i need to findout duplicates out of this huge data. Pls assist with formula.
Nice sir
Good sir ji
Thnx u sir 🤗
Thanks Pari, Recommend you to start your learning journey from playlist Basic excel step by step in sequence followed with MIS interview cracker.Have a wonderful career ahead❤️❤️❤️👍
Jahan pr error a raha h bahan par if error ka bhi use ya fir if blank ka bhi use kar sakte h sir
Bikul iferror use kar lijiye ya..if aur uske inside iserror bhi kar sakte hain..better rhega koi bhi formula lagayen to uske bahar iferror jarur lagayen.
But is Question ke case me iferror se solution nhi ho payega jo hum chahte hain..hope aapko aajke video pasand aaye honge aur apne seekha hoga .
That was a great Tip. What if there lots of conditions. "Count Uniques with CountIfs"
❤️🙏
Thnq sir
sir jee, i m from Pakistan, this sumproduct formula not working when we apply filters, please resolve ?
thanks
Thnsk dear🙏❤️🙂
Sir How we count unique in filtered column having with mixed data #N/A
Like column values 101, 103, #N/A, 101, 105. If we want to get unique value in filtered how we can get it.
Sir 10:05 me aakhir me range ke sath ampersand kyu lagaya
Hallo Sir, how if I wanna use multiple criteria for instance "=Sumproduct(1/countifs(...))"?
You may check Playlist Interview crack recent episode crack jobs #24 q4 ,you may get the answer for the same.🙏❤️
@@Innozant Okay. I will check it. Thank you.
how to findout unique count & Details Different cell, Please reply me 🙏🙏🙏
Sir can you please make a video on Creating a unique List. (without using unique formula)?
Unique list question is already there in interview Cracker series.Ok will make seprate video for the same.❤️🙏
Sir if I want to count Mondays or any other day present/absent only in an attendance sheet. How can I do it in excel. Kindly consider this urgent. Make a video on this topic
Kindly watch excel maharaj series..Your related solutions are there
But this is not working in pivot for unique count with total
Revise, relearn, recap, RRR