Hey, Can you Input a coloumn with Product Amounts then make summary on sum of product amounts with unique segments and products, i m very thankful if you do this for me.
You can select blank cells but SUMPRODUCT may increase file size or work very slow if you input large data range inside the formula. Instead of that you can use SUMIFS. To know about SUMPRODUCT in depth follow the link below ruclips.net/video/GkWwEZwS5iE/видео.html
Second formula using in office 365 not a perfect there is some issue. If there is a another item in segment just like a printer but if is not in your data the result for this segment its zero but using this formula it shows one value for this segment how is possible if this segment is not in data.
MS 365 wala formula chalega nahi agar condition aisi ho ki filter ki value 0 ho to unique count error hoga or counta use result 1 consider karega which is wrong
Step-1 :- Filter Function bring out all the record from the range Step-2 :- Filtered record may have duplicate record hence used Unique function to get the unique list Step-3 :- Counta Function counting the all unique records Hope you understand it. if have any doubt reachout through Whatsapp Massage @9708153000
@@ExcelUniverse thanks for explaining further but still i cannot do my assignment at work. I need to get the number of unique data for specific item for an specific range date. P.S whatsApp number is not correct, or what's the code? thank you again
@@ExcelUniverse in the sample data i need to count the unique number of DV for the month of january per code number i hope sir that you would give me formula for this thank you so much sir
Thanks Rahul Gupta Jee, Your has made me think on it. Its happen with Office 365 solution, because excel understand that each empty cell is equals to zero and if any cell is blank its a new entity for that particular entry, that's why count is getting increase. I have updated the file link in video description with your query, kindly download the same.
Superb Sir, Meri bhi ek query hai. Sir Meri Query ye hai Apple 1 bar aya to usko unique value ke saath count bhi kiya jaye jaise 1/1 or jab dobara aye to 1/2 or phir dobara aye to 1/3 resut mile isi tarah Laptop 2/1, 2/2, 2/3 or Tablet 3/1, 3/2 Samajh Orange 4/1 Samajh gaye na Sir please meri ye query aap solve karden plz...
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
I got many comments on the same issue. Sorry for that. You may download the file from the link below to get the correct result mega.nz/file/pqp0TBpQ#zSOlsBqn0LUR3poOfYU3AGNmVR9aRRe0c80P9Jp2LNk
![Count unique distinct values meeting criteria [Array Formula]](/img/1.gif)
Thanks, dear I searched for this solution for a long.
I'm glad my videos are helping you,
But if you are applying this trick on a large database then be careful as excel will hang.
Good explanation..
My problem solved.
Glad it helped
Bohot badhiya sir ji
🙏✨️
Great Solution Thanks for the video
Thanks
good explanation but please avoid adding music while explaining
Thanks for your valuable feedback.
Thanks for the video
Most welcome 🙏
Hey, Can you Input a coloumn with Product Amounts then make summary on sum of product amounts with unique segments and products, i m very thankful if you do this for me.
You need to connect on anydesk with the data. Definitely I will help you on it.
Whatsapp me on 97081 53000
I have issue in one excel sheet kya aap help kr skte hain?
Sure
@@ExcelUniverse where to connect?
Whatsapp at 97081 53000
@@ExcelUniverse OK sir
Good video, Kindly release English Version also,,,
Thanks
Will try
nice video sir❤❤❤❤
Thanks and welcome
Old method sir, we have very advanced functions by their combination of use, it can be a lot easier.
Yes
The Microsoft 365 Excel having lot of powerful functions that can be used for it.
Very Helpful
Glad it helped
Very valuable video 👍🙏🙏🙏
Thanks a lot
Dear Sir how to do sumproduct formula in extra range like blanck cell in multiple criteria, please advice ..Thank you in advance..
You can select blank cells but SUMPRODUCT may increase file size or work very slow if you input large data range inside the formula. Instead of that you can use SUMIFS.
To know about SUMPRODUCT in depth follow the link below
ruclips.net/video/GkWwEZwS5iE/видео.html
Very helpful. However, I'm stuck with a problem. Instead of managers, I've got dates and i want the same filter to work for future dates as well
Can you please share any sample file on WhatsApp @9708153000
Amazing sir
Thanks and welcome
Second formula using in office 365 not a perfect there is some issue. If there is a another item in segment just like a printer but if is not in your data the result for this segment its zero but using this formula it shows one value for this segment how is possible if this segment is not in data.
Download the file from the link in Description, your requirements is taken care there
Thank you
🙏
MS 365 wala formula chalega nahi agar condition aisi ho ki filter ki value 0 ho to unique count error hoga or counta use result 1 consider karega which is wrong
Yes, you are right.
how about this formula counta(unique(filter and with specific range date. would be very glad if you could teach me how
thank you
Step-1 :- Filter Function bring out all the record from the range
Step-2 :- Filtered record may have duplicate record hence used Unique function to get the unique list
Step-3 :- Counta Function counting the all unique records
Hope you understand it. if have any doubt reachout through Whatsapp Massage @9708153000
@@ExcelUniverse thanks for explaining further but still i cannot do my assignment at work. I need to get the number of unique data for specific item for an specific range date.
P.S whatsApp number is not correct, or what's the code?
thank you again
@@ExcelUniverse in the sample data i need to count the unique number of DV for the month of january per code number
i hope sir that you would give me formula for this
thank you so much sir
Whatsapp Number is working 9708153000
Thanks a Ton 🙏
Most welcome!
Love youu sir g❤❤❤
😊
Great solution. But if we have blank cell in our data then it give you one extra count. how to ignore it
Thanks Rahul Gupta Jee, Your has made me think on it.
Its happen with Office 365 solution, because excel understand that each empty cell is equals to zero and if any cell is blank its a new entity for that particular entry, that's why count is getting increase.
I have updated the file link in video description with your query, kindly download the same.
Dear Sir, How can I fix the data that is not in the table but writes 1 in the result
You need to download the file from the link in Description! It's already Solved and store in file
Nice Sir..
Thanks and welcome
Superb Sir, Meri bhi ek query hai.
Sir Meri Query ye hai Apple 1 bar aya to usko unique value ke saath count bhi kiya jaye jaise 1/1 or jab dobara aye to 1/2 or phir dobara aye to 1/3 resut mile isi tarah Laptop 2/1, 2/2, 2/3 or Tablet 3/1, 3/2 Samajh Orange 4/1 Samajh gaye na Sir please meri ye query aap solve karden plz...
="1/"&COUNTIF($A$2:A2,A2)
A column me aapka data hoga jisme apple ho sakta hai
Or Maine jo formula upar bataya hai use B2 me input Kar dijiye
@@ExcelUniverse Sir aap mujhe apna email address dijiye main wahan send karta hoon sheet ko
Premkantpandey@yahoo.com
@@ExcelUniverse Sir maine Send kardi image aap dekh kar samjh jayen ge meri prob
Also possible with SUMPRODUCT
👌
Hi sir how to skip duplicate & count without delete any data? Is there any equation for this?
You mean, cout only record that appear once?
If yes then use COUNTIFS with SUMPRODUCT.
=SUMPRODUCT(--(COUNTIFS(range,range)
Thank you sir 🥰👍
Nice
🙏
I have some doubt in my sheet can you help me in it
Sure
Pls share file @ 9708153000 with desired result
@@ExcelUniverse how can I send it to you
On WhatsApp number given
9708153000
@@ExcelUniverse ok
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
You can use UNIQUE Formula that's available in Office 365 or office 2021
how to absent employees name highlight according to date in attendance sheet
Can you please share any file with desired result.
It's better to understand
Whatsapp @ 9708153000
If there is no unique items matching the criteria still it is showing 1
I got many comments on the same issue. Sorry for that.
You may download the file from the link below to get the correct result
mega.nz/file/pqp0TBpQ#zSOlsBqn0LUR3poOfYU3AGNmVR9aRRe0c80P9Jp2LNk
Sir agar blank hi cp code to count Nhi kr rha unique me cp code pls suggest...
Once again select that range and put "" in criteria
Well You can download file from the description, solution is provided as you want
Counta returns 1 when answer is zero ..
Cloud you please please me to fix this
Download the file from the link to get your answer
mega.nz/file/pqp0TBpQ#zSOlsBqn0LUR3poOfYU3AGNmVR9aRRe0c80P9Jp2LNk
Is your name premkank
Prem Kant Pandey
Sir Maine Try kiya par choti si problem hai is formula main plz aap theek karden..
MATCH(C2,$C$2:$C$10,0)&"/"&COUNTIF($C$2:C2,C2)
Asp file share kariye whatsapp me
I have one dought
Yes
High number count showing in decimal. How to solve it
Can you please share file where formula applied
WhatsApp @9708153000
👍
🙂
What language is this?
language ?
❤❤❤❤❤❤
😍
Why is the description in English but the video is not?
What you want?
सेल A1 के अंदर 11 हो और A2 सेल में 12 टाइप करे तो वो रेड कलर मे आ जाए ,A2 में टाइप करे 10 तो वो ग्रीन कलर आए ,
तो सर ऐसा कोई फॉर्मूला है ?
Try conditional formatting
Agr kuch nahi hai to zero nahi dy rahaa hai
Pls share your file where you applied formula. Whatsapp at 97081 53000
Manger 2 Mai cp1 hoga to kaise hoga
CP1 किसी एक ही मैनेजर के साथ हो सकता है।
Sir is me 1 dy rhaa formula
Pls share your file
please dont put background music, it is distracting
Sorry for that, now I am not using music in video
Apke subscriber kitne hi
??
very complex and old school..sorry...there is much better way
🙂
Irritating music
Sorry for inconvenius. Well I am not using music in future videos