finding maximum sales of product when duplicate products

Key Takeaways

hi friends this is a ragnikant excel guru and here i am going to explaining you the how to get a maximum sales product when it is having some duplicate okay so we have to find that one so how do you how you'll find wait a minute i'll show you before going that before going to main session so i am asking you how to do so here is the explanation the previous guy did like this okay so this is not the right answer which i am going to tell you okay so here it is so he did summit okay i want this one should be here like this not this all helper columns i don't need all these helper columns only this one should come here in hello right so before going to that i will now i'll show you how to do right if you have any doubts please ask me in the comment box or in my group now here already said that it is the procedure to find it an individual total okay easily you can get like this that here after completion of this like get some by using summit you can use this like this max of this f4 match of this whole thing comma the local value will be this one okay here you can get the right answer but i don't need that one like this without i need without helper column index of this as for comma it's an array function you have to use ctrl shift and enter so see so i don't need all the helper columns i need that cancel and here first of all i will do countif also let me explain you why i am using this one countif the range this one i have 4 comma this one okay 5 double click ok 5 7 nine why i'm doing this everything now after doing the total of the product we have to find the maximum sales of the product first of all we have to find this maximum sorry some of the codes individually in one cell okay in one can not like this okay i'll do one thing i'll copy this whole thing ctrl x here control z see how i'll do series let me decrease the column width [Music] okay now here it is now we have to find the corrective not not like this procedure in single cell so what i'll do i'll do sum if right which is the right the range will be this right has four comma and the criteria will be we don't know the criteria we have to find that so i will take this whole thing again so it will become an array and the sum range will be this one now see how it will give the answer this number will repeat five times and this number will repeat seven times and this number will repeat nine times five seven nine okay s9 see first number five times nine eight two six two nine eight two sixty two times is over three times nine eight two six two nine eight two six two nine eight two six two so this one okay this is occurring five times so it is adding those sum those sum of the amount and showing five times right so from here we have to get the maximum test here also the same thing it is repeating seven times the product not for us oh yes the purple three is repeating five times and product two is repeating seven times right so see how i'll do here now i'll copy this one whole thing now i'll use maxo it's an array function if you do the control shift and enter it will give this access understood the dice which i am going to explain you if you have any doubt ask me and now we got the sale of total but we have to find the product so what i'll do simply i use match of this command look up arrange the same lookup value this one this one okay number two is not there only that thing and match is this thing comma zero now it has become an array again so you have to use the same key stroke that is control shift and enter so it will give you the position too because here it is there it is it is having duplicated to ignore the duplication you have to find the f2 index of this whole thing f4 comma and ctrl shift and enter thank you guys i'm getting a call sorry i'll catch you later please like share and subscribe