I have a list where the unique identifying number repeats several times because of multiple items (different sku numbers). This data also contains an inventory column, sku count column, and variance column.
Other than a pivot table, is there another way where I could rank the variance of each sku separately on the same sheet?
Basically, I want to return the top 25 stores with the worst variance for each SKU
The Sheet looks like:
A B C D E
Store# SKU Inventory Count Variance
Other than a pivot table, is there another way where I could rank the variance of each sku separately on the same sheet?
Basically, I want to return the top 25 stores with the worst variance for each SKU
The Sheet looks like:
A B C D E
Store# SKU Inventory Count Variance