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.
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.
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 👍
I have seen so many tutorials in TH-cam, 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...
नमस्ते सर जी, सर आपने Sumproduct and CountIF with Unique Values बहुत ही डिटेल मैं और अच्छे से समझाया | मुझे आज नई चीज़ सीखने को मिली | आपका बहुत बहुत धन्यवाद सर जी |
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
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
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
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
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.
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
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❤️❤️❤️👍
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
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.
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.
Thanks a lot 👍..After watching this video I am able to do it. But, Pls teach in English sir... I am not able to understand the reason y the dividing consept is used.
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, 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
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
Hello Sir, Thanks for making the videos and motivate us to learn always new things. As you explained the unique count without helping column, could you please help me to calculate the total count of duplicate value without helping column.
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
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 ❤️
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.
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
I have seen so many tutorials in TH-cam, 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 .
नमस्ते सर जी, सर आपने Sumproduct and CountIF with Unique Values बहुत ही डिटेल मैं और अच्छे से समझाया | मुझे आज नई चीज़ सीखने को मिली | आपका बहुत बहुत धन्यवाद सर जी |
Thanks Sandeep Ji..Aaj Live Interview of MIS EXECUTIVE video aane wala hai..must watch
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..❤️
Way of explanation is excellent, thanks for sharing your vedios.
Sir, excellent video, aapne bahut easy kar diya
Thanks Vikram Ji
Nice video.. i am looking this formula from last 1 week....
Thanks.
Best indian excel guide!!🔥🔥
Thanks dear
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
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 ❤
Ye series sabse alag hai sir. Baar bar dekhta hu mai
Good Shrikant..Aap revision mode on kar rakhe hain aapna..Keep growing
Sir ji apka vedio or smjane ka trika bhut acha h ase hi vedio bnate rhna
Thanks dear..Humesha milta rahega videos seekhne ko..
YOU ARE BRILLIANT!
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❤️😊
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
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
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.
bahut help hua sir
THANKS SIR!!!!!!
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
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
Hi Dilip Sir,
Will you please tell me the process to extract uncommon record set from different sheet or different workbook?
Searching for this type of formula..
Thanks
❤️👍
Thankyou very much!
Great way of explaining the things. Really nice 👌👌👌👌👌
Thanks Vikrant Ji.Happy learning
Good teaching
Amazing
Thanks for this
Mind-blowing sir
I have a question how to count of only capital letter Text in column
Very well explained...
Thanks Shreya..Keep Learning ..Keep exploring
Thanks for videos sirG
Thanks dear ❤️
Your way of teaching is quite good... Keep doing good work for learners...🙏
Thanks Vishwadeep ji..Happy learning
really good explanation
Thanks Charvie.We welcome you to experience the taste of success with Innozant -Seed of success. ❤️❤️❤️
Wow. Me bhi excel me job karta hu but esa logic me kabhi nahi soch skta
👍
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
Excellent!!!!
Thanks you sir for explain such important topics.
Thanks Hemant,Happy Learning
Excellent 👌 sir.. thanks for video.
Thanks Sandeep,Have a wonderful day.
Happy Learning
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.
Intelligent Sir
Thanks dear❤️
Excellent sir
Thanks dear
excellent sir..
Thanks Sridhar❤🙏
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..
Thanks 👍
Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence
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
Dive Deep Thats Innozant
Thanks
Very nice sir.
Thanks Bhoopi
Good sir ji
Sir unique count ka multiple sheet main bhi batao ek saath without unique and vstack ke
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
Thanks 🙏❤️
Bahot bahatreen. Sabhi formulas ka aapne postmortem kar rakha he
😊👍
Nice 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.
Sir, How to count Unique with multiple criteria like employee id wise channel partners...
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
Sir. Ek video esi bnau jisme pivot k through unique value count sum kr ske plz..
Macro with pivot table ke saath kese banayege. Video banaye.
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❤️❤️❤️👍
Revise, relearn, recap, RRR
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
Thnq sir
thanks
Thnsk dear🙏❤️🙂
you are really great sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
thanks dear❤❤
Can this be done with countifs
Isi farmule main fillter lagana batayiye
Filter bahar chala dijiye
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
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 .
Sir can we find the last nth match value?
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.
That was a great Tip. What if there lots of conditions. "Count Uniques with CountIfs"
❤️🙏
This use with filter
kindly help
This can be solved in this easy way also,
=COUNTA(UNIQUE(DATARANGE))
👍❤️
स्कूल के लिए कोई सॉफ्टवेयर आपकी तरफ से बनाया गया हो अथवा कोई सलूशन जो अधिकतर स्कूलों को परेशानी में डालता है कृपया मार्गदर्शन करें
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 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
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.❤️🙏
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.
How count days between two dates of list of items pls
Sir how to get distinct count by formula ??
sir aapke concept mr mike jese hai "Excel fun"
🙏🙏🙏🙏
insted of blank if few cells contain "-", then how to delete count of "-"
Sir agar hmaari range pure column ki hai A:A h tab kya karrnge.
Thanks a lot 👍..After watching this video I am able to do it. But, Pls teach in English sir... I am not able to understand the reason y the dividing consept is used.
Thanks Jegan..
Please forward 50 % video. See Main tropics
DATE WISE MANOPOWR UNIQUE COUNT KA FORMULA BATAYE SIR, LIKE 15 MAY AMAN, JITENDRA = 2 , PLEASE
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.
Please help me unique count but only visible cell
Need some knowledge in Web excel
Ok .topic please ..will guide you
@@Innozant sir, we do have lot of works in sharepoints with multiple sheets, please guide us to report connection with 3 multiple sheets in one pivot.
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,
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
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
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.
Hello Sir,
Thanks for making the videos and motivate us to learn always new things. As you explained the unique count without helping column, could you please help me to calculate the total count of duplicate value without helping column.
Ok..in upcoming videos will try to add this question.
@@Innozant Thanks Sir.
I will wait for that video.