Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can someone show me how to accomplish the following by using the LARGE
function "WITHOUT" using an array ? I'm trying to rank each product (most, second most, etc.) by weight. Data worksheet A B C 1 Product Type Pounds 2 Orange Fruit 600 3 Tomato Vegetable 500 4 Apple Fruit 700 5 Potato Vegetable 1,000 Using the LARGE function, the goal is to get the following result on another worksheet: Order worksheet A B C 1 Product 1 2 2 Fruit Apple Orange 3 Vegetable Potato Tomato On the Order worksheet, the following formula is the one I'm using with an array: {=IFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data !$B$1:$B$5= $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1)," ")} Does anyone know how to get the same result without using an array - even if it uses another function ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Criteria governing "LARGE" function | Excel Discussion (Misc queries) | |||
Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Looking up the results from the function "LARGE" | Excel Worksheet Functions | |||
Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) |