If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help using the LARGE function "WITHOUT" using an array
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 | |
Display Modes | |
|
|