How to sort highest performing category of products based from values?

[cresscendo]

Hi everyone this is my first post :D found this site after some frustation searching for a simple formula that could fix problems i have


So what i am making is a list of product COGS, it has name of the product, the base cost, the months it is sold and the content of this table is how many of the producst are sold in a certain month and the total cost incurred on that month

what i want and stuck with is that how to create a table that can figure out what product creates the biggest cost on that month, i can figure out which one generates the most with MAX() function but i am stuck with how to reference the highest value excel find with that function and turn it into a cell adress that i can use to refer to the collumn that contains the name of the product..

this is what i am working on atm

you can see that i managed to get excel figure out which of the products sold within the month cost the most ( at 714, 560 in march 2018) but i'm not sure what function that can turn that value back into "which cell it belongs to" and use that information to refer to which cells in Collumn B (which contains the name of the product) so that this formula should be able to figure out on each month, what is the biggest cost in that month and find the name of the product it belongs to.. and present the value as the "Name of the product" based on Collumn B instead of dislaying the highest cost of the month.

if anyone can help me sort this out it would be very appreciated

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[shukla.ankur281190]

May be try in

G2

Please Login or Register  to view this content.