Eugenio1991
New Member
- Joined
- Jul 30, 2018
- Messages
- 4
Good Day All ,
Need Help , Im trying to write a formula that will return sorted values base on two criteria, currently working with one . Example is below,
Data is from Sku to Ranking . Formula is written on the Answers line..
i need the formula to return the values per "PK" line base on the ranking given.
Current formula i use is "=IFERROR(INDEX($A$3:$A$250, MATCH(0, IF("Pk10Y"=$AF$3:$AF$250, COUNTIF($AJ$14:AJ22, $A$3:$A$250), ""), 0))," ") but only work for the Pk criteria and need to add the ranking.
any help if welcome .
Thank You.
<colgroup><col><col><col><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
Need Help , Im trying to write a formula that will return sorted values base on two criteria, currently working with one . Example is below,
Data is from Sku to Ranking . Formula is written on the Answers line..
i need the formula to return the values per "PK" line base on the ranking given.
Current formula i use is "=IFERROR(INDEX($A$3:$A$250, MATCH(0, IF("Pk10Y"=$AF$3:$AF$250, COUNTIF($AJ$14:AJ22, $A$3:$A$250), ""), 0))," ") but only work for the Pk criteria and need to add the ranking.
any help if welcome .
Thank You.
SKU | Description | PK Line | Ranking | Answers Line 1 | Answers Line 2 | Answers Line 2 | ||
75069115 | Org Baby Kale 100%, 6X9 oz, BIL Clam, og | 1 | 3 | 75069415 | ||||
75069215 | Org Baby Kale 100%, 6X9 oz, SPEC Clam, og | 2 | 2 | 75069315 | ||||
75069415 | Org Baby Kale 100%, 6X9 oz, SPEC BIL Clam, og | 1 | 1 | 75069115 | ||||
75069315 | Org Baby Kale 100%, 6X9 oz, Clam, og | 1 | 2 | |||||
39000017 | Org Baby Spinach, 6X1 LB SPEC BIL Clam, og | 2 | 2 | |||||
39000006 | Org Baby Spinach, 6X1 LB SPEC Clam, og | 2 | 1 | |||||
39060315 | Org Baby Spinach, 6X1 LB BIL Clam, og | 3 | 2 | |||||
39061615 | Org Baby Spinach, 6X1 LB Clam, og | 3 | 1 |
<colgroup><col><col><col><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>