Spreadsheet: 883890d1732640112-ranking-formula-in-a-ranks-each-upc-by-its-sales-with-its-category-column-d-formula-help
Sheet: Sheet1

A | B | C | D | E
CATEGORY RANK | UPC | ITEM | CATEGORY | $
 | 61994700003 | TITO'S VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 19128080.4
 | 61994700002 | TITO'S VODKA 80 PROOF 750ML GLASS BOTTLE | VODKA | 9738954.36
 | 2113020824 | VITALI REG VODKA 80 PROOF 1.75L PLASTIC BOTTLE | VODKA | 8071867.17
 | 8500002986 | HIGH NOON VDK SLTZR ASSORTED CK <43 PROOF 355ML ALUMINUM CAN 12PK | PREPARED COCKTAILS | 7339486.9
 | 8200072760 | SMIRNOFF REG VODKA 80 PROOF 1.75L PLASTIC BOTTLE | VODKA | 6970806.49
 | 8043250017 | JAMESON REG IRISH WHISKEY 80 PROOF 750ML GLASS BOTTLE | WHISKEY | 6038767.45
 | 8515680368 | KETEL ONE REG VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 5927392.45
 | 8218409046 | JACK DANIELS BLACK BRBN WSKY 80 PROOF 750ML GLASS BOTTLE | WHISKEY | 5102893.83
 | 8218409042 | JACK DANIELS BLACK BRBN WSKY 80 PROOF 1.75L GLASS BOTTLE | WHISKEY | 4946419.85
 | 72105901750 | SKYY REG VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 4863255.24
 | 61994700001 | TITO'S VODKA 80 PROOF 1L GLASS BOTTLE | VODKA | 4748572.35
 | 8800401272 | PLATINUM 7X VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 3955964.5
 | 81675102123 | CUTWATER LIME MARGARITA CK <43 PROOF 355ML ALUMINUM CAN 4PK | PREPARED COCKTAILS | 3548541.1
 | 8068600110 | [NAME] WSKY 80 PROOF 1.75L GLASS BOTTLE | WHISKEY | 3451033.29
 | 61776811117 | SVEDKA REG VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 3415661
 | 8500003255 | HIGH NOON VDK SLTZR TRP ASST CK <43 PROOF 355ML ALUMINUM CAN 8PK | PREPARED COCKTAILS | 3335860.64
 | 8500003151 | HIGH NOON VDK SLTZR ASSORTED CK <43 PROOF 355ML ALUMINUM CAN 8PK | PREPARED COCKTAILS | 3236684.18
 | 8043250018 | JAMESON REG IRISH WHISKEY 80 PROOF 1.75L GLASS BOTTLE | WHISKEY | 3152230.09
 | 8200000950 | SMIRNOFF REG VODKA 80 PROOF 750ML PLASTIC BOTTLE | VODKA | 3111382.74
 | 8524613943 | MAKER'S MARK REG BOURBON WSKY 90 PROOF 750ML GLASS BOTTLE | WHISKEY | 3084820.93
 | 8024400923 | BUFFALO TRACE BOURBON WHISKEY 90 PROOF 750ML GLASS BOTTLE | WHISKEY | 2983252.38
 | 8811015055 | HENNESSY VS COGNAC 80 PROOF 750ML GLASS BOTTLE | COGNAC | 2936761.65
 | 85672400611 | CASAMIGOS [NAME] 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2827777.4
 | 81175102004 | STOLI REG VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 2820731.41
 | 8048028002 | GREY [NAME] VODKA 80 PROOF 750ML GLASS BOTTLE | VODKA | 2784466.57
 | 72105970750 | ESPOLON BLANCO TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2783502.53
 | 81153801085 | JOSE CUERVO ESPL SLVR TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2770203.62
 | 8515651541 | KETEL ONE REG VODKA 80 PROOF 750ML GLASS BOTTLE | VODKA | 2758891.86
 | 83522900060 | ABSOLUT REG VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 2671866.65
 | 81153801077 | JOSE CUERVO ESPL SLVR TEQUILA 80 PROOF 1.75L GLASS BOTTLE | TEQUILA | 2627669.83
 | 8048001520 | [NAME] 80 PROOF 1.75L GLASS BOTTLE | RUM | 2611230.8
 | 72105900131 | APEROL <43 PROOF 750ML GLASS BOTTLE | CORDIALS | 2589140.25
 | 72173300002 | PATRON SILVER TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2572476.47
 | 8700000552 | BULLEIT BOURBON WHISKEY 90 PROOF 750ML GLASS BOTTLE | WHISKEY | 2435539.19
 | 8048017002 | CAZADORES RPSDO TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2423216.95
 | 8068683532 | HORNITOS PLATA TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2375736.27
 | 8700000725 | CROWN ROYAL REG CANADIAN WSKY 80 PROOF 750ML GLASS BOTTLE | WHISKEY | 2359757.37
 | 83522900030 | ABSOLUT REG VODKA 80 PROOF 750ML GLASS BOTTLE | VODKA | 2260212.48
 | 8800402049 | FIREBALL CINNAMON CNDN WSKY 43-69 PROOF 50ML PLASTIC BOTTLE 10PK | WHISKEY | 2217811.41
 | 8068600140 | [NAME] WSKY 80 PROOF 750ML GLASS BOTTLE | WHISKEY | 2205618.35
 | 8200000006 | SMIRNOFF REG VODKA 80 PROOF 750ML GLASS BOTTLE | VODKA | 2202796.8
 | 85271400694 | ROUND ROCK VODKA 80 PROOF 1.75L GLASS BOTTLE | VODKA | 2177419.42
 | 8500003609 | HIGH NOON TQLA SLTZR VRTY CK <43 PROOF 355ML ALUMINUM CAN 8PK | PREPARED COCKTAILS | 2173702.19
 | 8676721006 | BAILEYS ORIGINAL CORDIALS <43 PROOF 750ML GLASS BOTTLE | CORDIALS | 2138536.05
 | 8068683502 | HORNITOS RPSDO TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2136164.79
 | 8048017202 | CAZADORES BLANCO TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 2119841.51
 | 81153801076 | JOSE CUERVO ESPL GOLD TEQUILA 80 PROOF 1.75L GLASS BOTTLE | TEQUILA | 2112576.14
 | 8811011050 | TANQUERAY GIN 95 PROOF 1.75L GLASS BOTTLE | GIN | 2099872.43
 | 8700070070 | SEAGRAM'S 7 CROWN BLND WSKY 80 PROOF 1.75L GLASS BOTTLE | WHISKEY | 2040899.3
 | 8112800150 | WOODFORD RSRV BOURBON WSKY 90 PROOF 750ML GLASS BOTTLE | WHISKEY | 2003470.34
 | 8200075910 | CAPTAIN MORGAN SPICED RUM 70 PROOF 1.75L PLASTIC BOTTLE | RUM | 2003409.81
 | 67454500041 | DON JULIO RPSDO TEQUILA 80 PROOF 750ML GLASS BOTTLE | TEQUILA | 1992075.96