Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I am interested in returning the name(s) of a product if it is one of the top 5 money makers for the year. I believe the large() can return me the top 5 products but 1) what if two or more products have the same value (for example see below how the top money maker is 500 but it is for both Product A and Product C) and 2) how do I return both the names of the products that meet this condition? In summary, so even though I want the Top 5 products, there could be more than 5 products because some products have the same value but I want to list out all the products that meet these conditions. Please help Thank you, Dan Ex. Product $ Product A 500 Prodcut B 100 Product C 500 Product D 400 Product E 300 Product F 200 Product G 100 Product H 100 .... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not enough memory for large workbooks | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Excel should be able to compute the MOD of large numbers. | Excel Worksheet Functions | |||
How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
finding common numbers in large lists | Excel Worksheet Functions |