I am trying to list the top 25 combinations 'over' and 'under' based on the combination in column O by either using the variance in column R or the amount 'over' and 'under' in columns S and T respectively having the top 25 'over' populate in column U and the top 25 under populate in column V.
Note: the number of top "combinations" needs to be able to change from 25 to 10 etc when needed.
<tbody>
</tbody>
Thank you!!
Note: the number of top "combinations" needs to be able to change from 25 to 10 etc when needed.
I | J | L | M | O | P | Q | R | S | T | U | V |
APO Product No-FRZ | Description | Regional | Regional Name | CONCAT REGIONAL AND MATERIAL | Total Order Qty (cases) | Forecast (cases) | Variance (cases) | 3 of cases over fcst | # of cases under fcst | Top 25 Over | Top 25 Under |
39677230301 | PLAIN BAGEL 4.5OZ KOSHER | 9200000 | ALBERTSONS LLC | 920000039677230301 | 0 | 0 | 0 | 0 | 0 | ||
39677230318 | CINNAMON RAISIN BAGEL 4.5OZ KOSHER | 9200000 | ALBERTSONS LLC | 920000039677230318 | 504 | 0 | 504 | 504 | 0 | ||
39677230325 | BLUEBERRY BAGEL 4.5OZ KOSHER | 9200000 | ALBERTSONS LLC | 920000039677230325 | 560 | 0 | 560 | 560 | 0 | ||
39677230417 | JALAPENO BAGEL 4.5OZ KOSHER | 9200000 | ALBERTSONS LLC | 920000039677230417 | 840 | 0 | 840 | 840 | 0 | ||
39677030307 | PLAIN BAGEL 4 5OZ | 9200004 | OTHER ONTARIO | 920000439677030307 | 7 | 20 | -13 | 0 | -13 | ||
39677030314 | CINNAMON RAISIN BAGEL 4 5OZ | 9200004 | OTHER ONTARIO | 920000439677030314 | 12 | 20 | -8 | 0 | -8 |
<tbody>
</tbody>
Thank you!!