Hello All,
I have a simple dataset with 'Category' and different product under each of those category and the quantity of product sold under each of these category.
I would like to have your help in creating a macro which can read the dataset and list all the unique category along with the product that has been sold the most under each of these categories.
I have attached the excel for reference.
Thanks
Formula for H13 =INDEX($A$5:$C$15,SUMPRODUCT(MATCH(MAX(($A$5:$A$15=G13)*$C$5:$C$15),--($A$5:$A$15=G13)*$C$5:$C$15,0)),2)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
The solution helps, however I am looking to do this in VBA.
Excel formulla may be the best and efficient solution, however the code suggestion requested is part of a vba program which I am trying to build
And your Macro can Enter that formula in cells in Range H13, or in any other range. Where is the issue?
Please Login or Register to view this content.
Last edited by mehmetcik; 03-11-2020 at 04:12 PM.
Thanks. it worked . However when I tried to pass the Row values to dynamic , it wasnt possible . I understood that what ever passed between "" is taken as such.
So is there a way to make the ranges used in this formula to be dynamic?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks