scottneill
New Member
- Joined
- Aug 30, 2011
- Messages
- 5
Hey!
i have an issue with an excel sheet. i have seen similar issues on this site just not sure how to apply to mine.
what i have so far is
model, how many i need, a part number, how many we have, how many after order
columns are A,B,C,E,F
I need to merge the duplicates based on the part number in colum C, i need the column B from both to be added and i need F to be E - total C.
there at columns A-N. other then the columns above the current data can be removed.
<table border="0" cellpadding="0" cellspacing="0" width="1429"><col style="width: 91pt;" width="121"> <col style="width: 49pt;" width="65"> <col style="width: 43pt;" width="57"> <col style="width: 50pt;" width="66"> <col style="width: 73pt;" width="97"> <col style="width: 92pt;" width="123"> <col style="width: 80pt;" width="106"> <col style="width: 26pt;" width="35"> <col style="width: 23pt;" width="31"> <col style="width: 27pt;" width="36"> <col style="width: 44pt;" width="59"> <col style="width: 79pt;" width="105"> <col style="width: 109pt;" width="145"> <col style="width: 287pt;" width="383"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 91pt;" width="121" height="17">USER PROFILE ID</td> <td class="xl65" style="width: 49pt;" width="65">ORD QTY</td> <td class="xl65" style="width: 43pt;" width="57">Part No</td> <td class="xl65" style="width: 50pt;" width="66">Store No.</td> <td class="xl65" style="width: 73pt;" width="97">QTY ON HAND</td> <td class="xl65" style="width: 92pt;" width="123">Parts After Order</td> <td class="xl65" style="width: 80pt;" width="106">QTY ON ORDER</td> <td class="xl65" style="width: 26pt;" width="35">SOS</td> <td class="xl65" style="width: 23pt;" width="31">MIN</td> <td class="xl65" style="width: 27pt;" width="36">MAX</td> <td class="xl65" style="width: 44pt;" width="59">STK IND</td> <td class="xl65" style="width: 79pt;" width="105">Description</td> <td class="xl65" style="width: 109pt;" width="145">Serial No</td> <td class="xl65" style="width: 287pt;" width="383">Note Data</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">2</td> <td> 5K9241</td> <td align="right">15</td> <td align="right">4</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">2</td> <td align="right">9</td> <td>S</td> <td>FITTING</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">3041817 OH</td> <td align="right">2</td> <td> 5P4254</td> <td align="right">15</td> <td align="right">9</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">6</td> <td align="right">17</td> <td>S</td> <td>BOLT</td> <td>7PZ</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">1</td> <td> 5P4539</td> <td align="right">15</td> <td align="right">1</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">1</td> <td>S</td> <td>CONE</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">1</td> <td> 5P4540</td> <td align="right">15</td> <td align="right">1</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">1</td> <td>S</td> <td>CUP</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">3041817 OH</td> <td align="right">12</td> <td> 5P6241</td> <td align="right">15</td> <td align="right">40</td> <td align="right">-20</td> <td align="right">0</td> <td align="right">0</td> <td align="right">39</td> <td align="right">54</td> <td>S</td> <td>BOLT</td> <td>7PZ</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1306634 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-5</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>APX</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-2</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>2BW</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1350471 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-1</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>ATY</td> <td>100% OH KIT</td> </tr> </tbody></table>
i have an issue with an excel sheet. i have seen similar issues on this site just not sure how to apply to mine.
what i have so far is
model, how many i need, a part number, how many we have, how many after order
columns are A,B,C,E,F
I need to merge the duplicates based on the part number in colum C, i need the column B from both to be added and i need F to be E - total C.
there at columns A-N. other then the columns above the current data can be removed.
<table border="0" cellpadding="0" cellspacing="0" width="1429"><col style="width: 91pt;" width="121"> <col style="width: 49pt;" width="65"> <col style="width: 43pt;" width="57"> <col style="width: 50pt;" width="66"> <col style="width: 73pt;" width="97"> <col style="width: 92pt;" width="123"> <col style="width: 80pt;" width="106"> <col style="width: 26pt;" width="35"> <col style="width: 23pt;" width="31"> <col style="width: 27pt;" width="36"> <col style="width: 44pt;" width="59"> <col style="width: 79pt;" width="105"> <col style="width: 109pt;" width="145"> <col style="width: 287pt;" width="383"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 91pt;" width="121" height="17">USER PROFILE ID</td> <td class="xl65" style="width: 49pt;" width="65">ORD QTY</td> <td class="xl65" style="width: 43pt;" width="57">Part No</td> <td class="xl65" style="width: 50pt;" width="66">Store No.</td> <td class="xl65" style="width: 73pt;" width="97">QTY ON HAND</td> <td class="xl65" style="width: 92pt;" width="123">Parts After Order</td> <td class="xl65" style="width: 80pt;" width="106">QTY ON ORDER</td> <td class="xl65" style="width: 26pt;" width="35">SOS</td> <td class="xl65" style="width: 23pt;" width="31">MIN</td> <td class="xl65" style="width: 27pt;" width="36">MAX</td> <td class="xl65" style="width: 44pt;" width="59">STK IND</td> <td class="xl65" style="width: 79pt;" width="105">Description</td> <td class="xl65" style="width: 109pt;" width="145">Serial No</td> <td class="xl65" style="width: 287pt;" width="383">Note Data</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">2</td> <td> 5K9241</td> <td align="right">15</td> <td align="right">4</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">2</td> <td align="right">9</td> <td>S</td> <td>FITTING</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">3041817 OH</td> <td align="right">2</td> <td> 5P4254</td> <td align="right">15</td> <td align="right">9</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">6</td> <td align="right">17</td> <td>S</td> <td>BOLT</td> <td>7PZ</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">1</td> <td> 5P4539</td> <td align="right">15</td> <td align="right">1</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">1</td> <td>S</td> <td>CONE</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046KIT</td> <td align="right">1</td> <td> 5P4540</td> <td align="right">15</td> <td align="right">1</td> <td align="right">-1</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> <td align="right">1</td> <td>S</td> <td>CUP</td> <td>2BW - DIFF & B/GEAR</td> <td>1256046 DIFFERENTIAL & BEVEL GEAR REBUILD KIT-OTML</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">3041817 OH</td> <td align="right">12</td> <td> 5P6241</td> <td align="right">15</td> <td align="right">40</td> <td align="right">-20</td> <td align="right">0</td> <td align="right">0</td> <td align="right">39</td> <td align="right">54</td> <td>S</td> <td>BOLT</td> <td>7PZ</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1306634 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-5</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>APX</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1256046 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-2</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>2BW</td> <td>100% OH KIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1350471 OH</td> <td align="right">1</td> <td style="background: none repeat scroll 0% 0% red;"> 5T5223</td> <td align="right">15</td> <td align="right">0</td> <td align="right">-1</td> <td align="right">4</td> <td align="right">0</td> <td align="right">2</td> <td align="right">3</td> <td>S</td> <td>SPIDER</td> <td>ATY</td> <td>100% OH KIT</td> </tr> </tbody></table>