Hey,
I can't work this one out and I've looked everywhere but can't wrap my brain around it properly.
I'm trying to return a value with 2 criteria and moving past the duplicates, from a standard INDEX MATCH SMALL IF ROW the ROW at the end returns the array of the SMALL but it's not moving past the duplicate.
Sample data with formulas in B2:B6 =INDEX(Dump!$G$5:$G$13147,SMALL(IF(Dump!$D$5:$D$13147=A2,IF(Dump!$R$5:$R$13147=E2,ROW(Dump!$G$5:$G$13147)-ROW(Dump!$G$5)+1)),ROW($1:1))) confirmed with CSE.
The -6 is a duplicate and I can't get past it, any help? If I hardcore the ROW($1:1) to 1 and then change the formula in B6 to a 2 it finds the duplicate.
Thanks,
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I can't work this one out and I've looked everywhere but can't wrap my brain around it properly.
I'm trying to return a value with 2 criteria and moving past the duplicates, from a standard INDEX MATCH SMALL IF ROW the ROW at the end returns the array of the SMALL but it's not moving past the duplicate.
Sample data with formulas in B2:B6 =INDEX(Dump!$G$5:$G$13147,SMALL(IF(Dump!$D$5:$D$13147=A2,IF(Dump!$R$5:$R$13147=E2,ROW(Dump!$G$5:$G$13147)-ROW(Dump!$G$5)+1)),ROW($1:1))) confirmed with CSE.
The -6 is a duplicate and I can't get past it, any help? If I hardcore the ROW($1:1) to 1 and then change the formula in B6 to a 2 it finds the duplicate.
Thanks,
Master Current Department Name | Master Line Number | Master Line Name | FC Sales TW | FC Sales vs LW |
NIGHTWEAR | 01H05MBLE | ESPRESSO YOURSELF | 0 | -7 |
NIGHTWEAR | 01T05MNUD | SHORT SATIN JERSEY | 6 | -6 |
NIGHTWEAR | 01M25LPNK | C+T ESME VINTAGE | 3 | -6 |
NIGHTWEAR | 01T03MBLE | TRSR JER OXF STRIPE | 0 | -6 |
NIGHTWEAR | 01T03MBLE | TRSR JER OXF STRIPE | 0 | -6 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>