Hi,
I need a formula to complete my workbook. I will describe the scenario based upon the attached workbook. Please see the sample worksheet. In row A I have a list of product names. The number of product is undefined. Sometimes I have 1 other times I may have 10. Each row for a product has a market cap. This data appears in column B. Currently, I have code that will spit out each unique product in K17 and going across. If I had 3 products. Product 1 would be in K17, product 2 would be in L17, product 3 would be in M17.
I am interested in created a formula that will output the largest and smallest market cap for each product. I would like this information to appear in K47:K48 and work across. See the result worksheet. I worked out the example manually.
Please help.
Bookmarks