1 or 0 based on Column Reference

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
180
I have spreadsheet and I need to number default images with a 1 and all other with a 0(zero). The Column F has the values from 1:1 through 7000+:1. Any cell with a :1 is a default image and needs a 1 in the M Column. Any other number than :1 is a 0 (zero). Thank you for any and all assistance, it is greatly appreciated.

Here is the Spreadsheet cut

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>F</th><th>G</th><th>H</th><th>M</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">ID</td><td style=";">Value(Value:Position)</td><td style=";">Supplier #</td><td style=";">Reference #</td><td style=";">Default (0/1)</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1</td><td style=";">1:1</td><td style=";">10-01</td><td style="text-align: right;;">1001</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1</td><td style=";">1:2</td><td style=";">10-012</td><td style="text-align: right;;">10012</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">2</td><td style=";">2:1</td><td style=";">10-50</td><td style="text-align: right;;">1050</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">2</td><td style=";">2:2</td><td style=";">10-502</td><td style="text-align: right;;">10502</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">2</td><td style=";">2:3</td><td style=";">10-505</td><td style="text-align: right;;">10505</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">2</td><td style=";">2:4</td><td style=";">10-507</td><td style="text-align: right;;">10507</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">3</td><td style=";">3:1</td><td style=";">10-89 04 W          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">3</td><td style=";">3:2</td><td style=";">10-89 05 W          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">3</td><td style=";">3:3</td><td style=";">10-89 08 R          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">3</td><td style=";">3:4</td><td style=";">10-89 11 W          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">3</td><td style=";">3:5</td><td style=";">10-89 14 R          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">3</td><td style=";">3:6</td><td style=";">10-89 14 W          </td><td style="text-align: right;;">1089</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">4</td><td style=";">4:1</td><td style=";">11-10</td><td style="text-align: right;;">1110</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">4</td><td style=";">4:2</td><td style=";">11-11</td><td style="text-align: right;;">1111</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">4</td><td style=";">4:3</td><td style=";">11-14</td><td style="text-align: right;;">1114</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">4</td><td style=";">4:4</td><td style=";">11-143</td><td style="text-align: right;;">11143</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">4</td><td style=";">4:5</td><td style=";">11-147</td><td style="text-align: right;;">11147</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">4</td><td style=";">4:6</td><td style=";">11-15</td><td style="text-align: right;;">1115</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">4</td><td style=";">4:7</td><td style=";">11-16</td><td style="text-align: right;;">1116</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">5</td><td style=";">5:1</td><td style=";">12-01</td><td style="text-align: right;;">1201</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">6</td><td style=";">6:1</td><td style=";">12-01F</td><td style=";">1201F</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">5</td><td style=";">5:2</td><td style=";">12-02</td><td style="text-align: right;;">1202</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">5</td><td style=";">5:3</td><td style=";">12-025</td><td style="text-align: right;;">12025</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">5</td><td style=";">5:4</td><td style=";">12-027</td><td style="text-align: right;;">12027</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">5</td><td style=";">5:5</td><td style=";">12-028</td><td style="text-align: right;;">12028</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">7</td><td style=";">7:1</td><td style=";">12-02F</td><td style=";">1202F</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">5</td><td style=";">5:6</td><td style=";">12-03</td><td style="text-align: right;;">1203</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">8</td><td style=";">8:1</td><td style=";">12-031F</td><td style=";">12031F</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">9</td><td style=";">9:1</td><td style=";">12-032F</td><td style=";">12032F</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">10</td><td style=";">10:1</td><td style=";">12-033F</td><td style=";">12033F</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">5</td><td style=";">5:7</td><td style=";">12-035</td><td style="text-align: right;;">12035</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;">11</td><td style=";">11:1</td><td style=";">12-03F</td><td style=";">1203F</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;">5</td><td style=";">5:8</td><td style=";">12-04</td><td style="text-align: right;;">1204</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;">8</td><td style=";">8:2</td><td style=";">12-041F</td><td style=";">12041F</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;">9</td><td style=";">9:2</td><td style=";">12-042F</td><td style=";">12042F</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;">10</td><td style=";">10:2</td><td style=";">12-043F</td><td style=";">12043F</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;">11</td><td style=";">11:2</td><td style=";">12-04F</td><td style=";">1204F</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;">5</td><td style=";">5:9</td><td style=";">12-05</td><td style="text-align: right;;">1205</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;">5</td><td style=";">5:10</td><td style=";">12-055</td><td style="text-align: right;;">12055</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;">12</td><td style=";">12:1</td><td style=";">12-06</td><td style="text-align: right;;">1206</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;">5</td><td style=";">5:11</td><td style=";">12-07</td><td style="text-align: right;;">1207</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;">13</td><td style=";">13:1</td><td style=";">12-08</td><td style="text-align: right;;">1208</td><td style="text-align: right;;">0</td></tr></tbody></table><p style="width:9.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Fox Combinations</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A2</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B2</th><td style="text-align:left">Replacement Boot Laces</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C2</th><td style="text-align:left">Black</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D2</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E2</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F2</th><td style="text-align:left">1:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G2</th><td style="text-align:left">10-01</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H2</th><td style="text-align:left">1001</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I2</th><td style="text-align:left">099598100100 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J2</th><td style="text-align:left">1.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K2</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L2</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M2</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A3</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">Replacement Boot Laces</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C3</th><td style="text-align:left">Sand</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D3</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E3</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F3</th><td style="text-align:left">1:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G3</th><td style="text-align:left">10-012</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H3</th><td style="text-align:left">10012</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I3</th><td style="text-align:left">099598100124 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J3</th><td style="text-align:left">1.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K3</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L3</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M3</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A4</th><td style="text-align:left">2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B4</th><td style="text-align:left">Blousing Garters</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C4</th><td style="text-align:left">Olive Drab</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D4</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E4</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F4</th><td style="text-align:left">2:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G4</th><td style="text-align:left">10-50</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H4</th><td style="text-align:left">1050</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I4</th><td style="text-align:left">099598105006 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J4</th><td style="text-align:left">0.6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K4</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L4</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M4</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A5</th><td style="text-align:left">2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B5</th><td style="text-align:left">Blousing Garters</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C5</th><td style="text-align:left">Khaki</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D5</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E5</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F5</th><td style="text-align:left">2:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G5</th><td style="text-align:left">10-502</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H5</th><td style="text-align:left">10502</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I5</th><td style="text-align:left">099598105020 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J5</th><td style="text-align:left">0.6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K5</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L5</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M5</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A6</th><td style="text-align:left">2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B6</th><td style="text-align:left">Blousing Garters</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C6</th><td style="text-align:left">Black</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D6</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E6</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F6</th><td style="text-align:left">2:3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G6</th><td style="text-align:left">10-505</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H6</th><td style="text-align:left">10505</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I6</th><td style="text-align:left">099598105051 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J6</th><td style="text-align:left">0.6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K6</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L6</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M6</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A7</th><td style="text-align:left">2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B7</th><td style="text-align:left">Blousing Garters</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C7</th><td style="text-align:left">Foliage Green</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D7</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E7</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F7</th><td style="text-align:left">2:4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G7</th><td style="text-align:left">10-507</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H7</th><td style="text-align:left">10507</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I7</th><td style="text-align:left">099598105075 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J7</th><td style="text-align:left">0.6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K7</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L7</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M7</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A8</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B8</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C8</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D8</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E8</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F8</th><td style="text-align:left">3:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G8</th><td style="text-align:left">10-89 04 W </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H8</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I8</th><td style="text-align:left">099598108991 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J8</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K8</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L8</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M8</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A9</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B9</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C9</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D9</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E9</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F9</th><td style="text-align:left">3:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G9</th><td style="text-align:left">10-89 05 W </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H9</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I9</th><td style="text-align:left">099598108953 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J9</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K9</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L9</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M9</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A10</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B10</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C10</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D10</th><td style="text-align:left">8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E10</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F10</th><td style="text-align:left">3:3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G10</th><td style="text-align:left">10-89 08 R </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H10</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I10</th><td style="text-align:left">099598108984 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J10</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K10</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L10</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M10</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A11</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B11</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C11</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D11</th><td style="text-align:left">11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E11</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F11</th><td style="text-align:left">3:4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G11</th><td style="text-align:left">10-89 11 W </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H11</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I11</th><td style="text-align:left">099598108199 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J11</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K11</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L11</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M11</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A12</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B12</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C12</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D12</th><td style="text-align:left">14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E12</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F12</th><td style="text-align:left">3:5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G12</th><td style="text-align:left">10-89 14 R </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H12</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I12</th><td style="text-align:left">099598108902 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J12</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K12</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L12</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M12</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A13</th><td style="text-align:left">3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B13</th><td style="text-align:left">GI Extreme Cold Weather Bunny Boots</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C13</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D13</th><td style="text-align:left">14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E13</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F13</th><td style="text-align:left">3:6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G13</th><td style="text-align:left">10-89 14 W </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H13</th><td style="text-align:left">1089</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I13</th><td style="text-align:left">099598109141 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J13</th><td style="text-align:left">45</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K13</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L13</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M13</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A14</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B14</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C14</th><td style="text-align:left">Olive Drab</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D14</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E14</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F14</th><td style="text-align:left">4:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G14</th><td style="text-align:left">11-10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H14</th><td style="text-align:left">1110</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I14</th><td style="text-align:left">099598111007 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J14</th><td style="text-align:left">1.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K14</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L14</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M14</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A15</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B15</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C15</th><td style="text-align:left">Black</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D15</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E15</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F15</th><td style="text-align:left">4:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G15</th><td style="text-align:left">11-11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H15</th><td style="text-align:left">1111</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I15</th><td style="text-align:left">099598111106 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J15</th><td style="text-align:left">1.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K15</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L15</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M15</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A16</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B16</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C16</th><td style="text-align:left">Woodland Camo</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D16</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E16</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F16</th><td style="text-align:left">4:3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G16</th><td style="text-align:left">11-14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H16</th><td style="text-align:left">1114</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I16</th><td style="text-align:left">099598111403 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J16</th><td style="text-align:left">1.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K16</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L16</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M16</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A17</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B17</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C17</th><td style="text-align:left">Digital Woodland</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D17</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E17</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F17</th><td style="text-align:left">4:4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G17</th><td style="text-align:left">11-143</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H17</th><td style="text-align:left">11143</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I17</th><td style="text-align:left">099598111434 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J17</th><td style="text-align:left">1.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K17</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L17</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M17</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A18</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B18</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C18</th><td style="text-align:left">Terrain Digital</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D18</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E18</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F18</th><td style="text-align:left">4:5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G18</th><td style="text-align:left">11-147</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H18</th><td style="text-align:left">11147</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I18</th><td style="text-align:left">099598111472 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J18</th><td style="text-align:left">1.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K18</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L18</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M18</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A19</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B19</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C19</th><td style="text-align:left">US Army Logo</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D19</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E19</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F19</th><td style="text-align:left">4:6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G19</th><td style="text-align:left">11-15</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H19</th><td style="text-align:left">1115</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I19</th><td style="text-align:left">099598111502 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J19</th><td style="text-align:left">2.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K19</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L19</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M19</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A20</th><td style="text-align:left">4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B20</th><td style="text-align:left">Nylon Commando Wallet</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C20</th><td style="text-align:left">USMC Logo</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D20</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E20</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F20</th><td style="text-align:left">4:7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G20</th><td style="text-align:left">11-16</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H20</th><td style="text-align:left">1116</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I20</th><td style="text-align:left">099598111601 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J20</th><td style="text-align:left">2.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K20</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L20</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M20</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A21</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B21</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C21</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D21</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E21</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F21</th><td style="text-align:left">5:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G21</th><td style="text-align:left">12-01</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H21</th><td style="text-align:left">1201</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I21</th><td style="text-align:left">023063104140 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J21</th><td style="text-align:left">4.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K21</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L21</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M21</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A22</th><td style="text-align:left">6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B22</th><td style="text-align:left">Fire Master Fog Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C22</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D22</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E22</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F22</th><td style="text-align:left">6:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G22</th><td style="text-align:left">12-01F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H22</th><td style="text-align:left">1201F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I22</th><td style="text-align:left">099598312015 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J22</th><td style="text-align:left">18.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K22</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L22</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M22</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A23</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B23</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C23</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D23</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E23</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F23</th><td style="text-align:left">5:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G23</th><td style="text-align:left">12-02</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H23</th><td style="text-align:left">1202</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I23</th><td style="text-align:left">023063105147 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J23</th><td style="text-align:left">5.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K23</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L23</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M23</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A24</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B24</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C24</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D24</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E24</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F24</th><td style="text-align:left">5:3</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G24</th><td style="text-align:left">12-025</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H24</th><td style="text-align:left">12025</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I24</th><td style="text-align:left">023063755144 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J24</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K24</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L24</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M24</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A25</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B25</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C25</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D25</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E25</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F25</th><td style="text-align:left">5:4</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G25</th><td style="text-align:left">12-027</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H25</th><td style="text-align:left">12027</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I25</th><td style="text-align:left">023063105154 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J25</th><td style="text-align:left">5.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K25</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L25</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M25</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A26</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B26</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C26</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D26</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E26</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F26</th><td style="text-align:left">5:5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G26</th><td style="text-align:left">12-028</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H26</th><td style="text-align:left">12028</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I26</th><td style="text-align:left">023063102153 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J26</th><td style="text-align:left">5.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K26</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L26</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M26</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A27</th><td style="text-align:left">7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B27</th><td style="text-align:left">Key Chain Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C27</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D27</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E27</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F27</th><td style="text-align:left">7:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G27</th><td style="text-align:left">12-02F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H27</th><td style="text-align:left">1202F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I27</th><td style="text-align:left">099598112028 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J27</th><td style="text-align:left">10.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K27</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L27</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M27</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A28</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B28</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C28</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D28</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E28</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F28</th><td style="text-align:left">5:6</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G28</th><td style="text-align:left">12-03</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H28</th><td style="text-align:left">1203</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I28</th><td style="text-align:left">023063102146 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J28</th><td style="text-align:left">4.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K28</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L28</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M28</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A29</th><td style="text-align:left">8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B29</th><td style="text-align:left">Cop Top Fog Cone Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C29</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D29</th><td style="text-align:left">3 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E29</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F29</th><td style="text-align:left">8:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G29</th><td style="text-align:left">12-031F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H29</th><td style="text-align:left">12031F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I29</th><td style="text-align:left">099598312312 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J29</th><td style="text-align:left">14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K29</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L29</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M29</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A30</th><td style="text-align:left">9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B30</th><td style="text-align:left">Flip Top Stream Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C30</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D30</th><td style="text-align:left">3 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E30</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F30</th><td style="text-align:left">9:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G30</th><td style="text-align:left">12-032F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H30</th><td style="text-align:left">12032F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I30</th><td style="text-align:left">099598312329 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J30</th><td style="text-align:left">15.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K30</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L30</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M30</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A31</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B31</th><td style="text-align:left">Flip Top Cop Med Fog Cone Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C31</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D31</th><td style="text-align:left">3 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E31</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F31</th><td style="text-align:left">10:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G31</th><td style="text-align:left">12-033F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H31</th><td style="text-align:left">12033F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I31</th><td style="text-align:left">099598312336 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J31</th><td style="text-align:left">15.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K31</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L31</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M31</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A32</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B32</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C32</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D32</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E32</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F32</th><td style="text-align:left">5:7</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G32</th><td style="text-align:left">12-035</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H32</th><td style="text-align:left">12035</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I32</th><td style="text-align:left">023063751146 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J32</th><td style="text-align:left">6.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K32</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L32</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M32</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A33</th><td style="text-align:left">11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B33</th><td style="text-align:left">Cop Top Stream Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C33</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D33</th><td style="text-align:left">3 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E33</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F33</th><td style="text-align:left">11:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G33</th><td style="text-align:left">12-03F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H33</th><td style="text-align:left">1203F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I33</th><td style="text-align:left">099598312039 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J33</th><td style="text-align:left">14</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K33</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L33</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M33</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A34</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B34</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C34</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D34</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E34</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F34</th><td style="text-align:left">5:8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G34</th><td style="text-align:left">12-04</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H34</th><td style="text-align:left">1204</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I34</th><td style="text-align:left">023063101224 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J34</th><td style="text-align:left">6.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K34</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L34</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M34</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A35</th><td style="text-align:left">8</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B35</th><td style="text-align:left">Cop Top Fog Cone Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C35</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D35</th><td style="text-align:left">4 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E35</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F35</th><td style="text-align:left">8:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G35</th><td style="text-align:left">12-041F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H35</th><td style="text-align:left">12041F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I35</th><td style="text-align:left">099598412418 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J35</th><td style="text-align:left">16.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K35</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L35</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M35</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A36</th><td style="text-align:left">9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B36</th><td style="text-align:left">Flip Top Stream Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C36</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D36</th><td style="text-align:left">4 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E36</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F36</th><td style="text-align:left">9:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G36</th><td style="text-align:left">12-042F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H36</th><td style="text-align:left">12042F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I36</th><td style="text-align:left">099598412425 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J36</th><td style="text-align:left">18.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K36</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L36</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M36</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A37</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B37</th><td style="text-align:left">Flip Top Cop Med Fog Cone Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C37</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D37</th><td style="text-align:left">4 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E37</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F37</th><td style="text-align:left">10:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G37</th><td style="text-align:left">12-043F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H37</th><td style="text-align:left">12043F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I37</th><td style="text-align:left">099598412432 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J37</th><td style="text-align:left">18.25</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K37</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L37</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M37</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A38</th><td style="text-align:left">11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B38</th><td style="text-align:left">Cop Top Stream Pepper Spray</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C38</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D38</th><td style="text-align:left">4 OZ.</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E38</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F38</th><td style="text-align:left">11:2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G38</th><td style="text-align:left">12-04F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H38</th><td style="text-align:left">1204F</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I38</th><td style="text-align:left">099598412043 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J38</th><td style="text-align:left">16.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K38</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L38</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M38</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A39</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B39</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C39</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D39</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E39</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F39</th><td style="text-align:left">5:9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G39</th><td style="text-align:left">12-05</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H39</th><td style="text-align:left">1205</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I39</th><td style="text-align:left">023063100227 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J39</th><td style="text-align:left">3.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K39</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L39</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M39</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A40</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B40</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C40</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D40</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E40</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F40</th><td style="text-align:left">5:10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G40</th><td style="text-align:left">12-055</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H40</th><td style="text-align:left">12055</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I40</th><td style="text-align:left">023063700229 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J40</th><td style="text-align:left">3.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K40</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L40</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M40</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A41</th><td style="text-align:left">12</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B41</th><td style="text-align:left">Police Magnum Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C41</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D41</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E41</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F41</th><td style="text-align:left">12:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G41</th><td style="text-align:left">12-06</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H41</th><td style="text-align:left">1206</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I41</th><td style="text-align:left">023063101200 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J41</th><td style="text-align:left">7.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K41</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L41</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M41</th><td style="text-align:left">1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A42</th><td style="text-align:left">5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B42</th><td style="text-align:left">Pepper Sprays Gel Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C42</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D42</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E42</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F42</th><td style="text-align:left">5:11</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G42</th><td style="text-align:left">12-07</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H42</th><td style="text-align:left">1207</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I42</th><td style="text-align:left">023063501802 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J42</th><td style="text-align:left">6.75</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K42</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L42</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M42</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A43</th><td style="text-align:left">13</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B43</th><td style="text-align:left">Police Magnum Advanced 3 in 1 Formaula Sabre Red</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C43</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D43</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E43</th><td style="text-align:left"> </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F43</th><td style="text-align:left">13:1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G43</th><td style="text-align:left">12-08</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H43</th><td style="text-align:left">1208</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I43</th><td style="text-align:left">023063601212 </td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J43</th><td style="text-align:left">7.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K43</th><td style="text-align:left">0</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L43</th><td style="text-align:left">10</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">M43</th><td style="text-align:left">0</td></tr></tbody></table></td></tr></table><br />
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
180
No Gaz they're which image is primary and the 0's indicate a child that belongs to the primary.
 

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
180

ADVERTISEMENT

This just gave me all 0's all the way down. Did you notice that the column is not B, but F?
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,982
Office Version
  1. 2016
Platform
  1. Windows
Try this

=IF(RIGHT(B2,1)=1,1,0)
That will fail if there can be 11 (or 21, 31, etc) images under a default image. Also, your test was wrong... you tested a piece of text against the number 1 instead of a text 1. For your formula, look at the last 2 characters and check for ":1". You can simplify the resulting formula like this...

=0+(Right(F2,2)=":1")

Note I used F2, not B2 as that was the column those values were in.
 
Last edited:

wynn89

Board Regular
Joined
Apr 8, 2015
Messages
97

ADVERTISEMENT

Hi,

You may want to try this

=IF(RIGHT(B2,LEN(B2)-FIND(":",B2))="1",1,0)

Regards,
Wynn
 

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
180
Rick,

Thank you, that did the trick. I appreciate your input and insight.
 

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
180
Wynn,

The column is not B it is F, but thank you also for your input and time.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,405
Messages
5,641,951
Members
417,249
Latest member
serrulate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top