Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using INDEX, MATCH & LARGE function to find a customer reference for top
3 values in a specific column in an array of data; Basically I use LARGE (1...3) to find the top five values, and use the MATCH function to find the row reference in the array. INDEX function then points to the array Row and Col for the customer representing that value. My problem is that the Match function always finds the first value if there are multiple equal values in the column. So if 2 values are equal, then match always picks the first of these values, even though Large 1 & Large 2 will find both values. How do I create a pointer reference to the second value (as selected by the Large function) CU_Array = $A$1:$C$5 REF = 1,2,3 can be one of 3 values A B C 1 Cust_Row1 100 200 2 Cust_Row2 67 150 3 Cust_Row3 100 125 4 Cust_Row4 156 200 5 Cust_Row5 120 100 The formula I am using is =INDEX(CU_Array,MATCH(LARGE(c1:c5,REF),c1:c5,0),0) Anyone have any suggestions... Thanks Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate values | Excel Worksheet Functions | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions | |||
Match function selecting first value it matches on exactly | Excel Worksheet Functions | |||
Duplicate fields does not match up! If statement | Excel Worksheet Functions |