ajcarlos18
New Member
- Joined
- Sep 4, 2017
- Messages
- 15
Hi,
I'm reading and using all the codes posted in most of the threads but I still found difficulty in running smoothly in my worksheet. May I ask for your help to formulate a code that will sum up all the duplicates in Criteria Range- column I (it will not include blank spaces) and sum range -column M and eventually deleting all the duplicates. Blank spaces in column I will remain as-is.
Here is the sample of the sheet:
<colgroup><col span="3"><col><col span="9"></colgroup><tbody>
</tbody>
Thank you very much for all your help.
I'm reading and using all the codes posted in most of the threads but I still found difficulty in running smoothly in my worksheet. May I ask for your help to formulate a code that will sum up all the duplicates in Criteria Range- column I (it will not include blank spaces) and sum range -column M and eventually deleting all the duplicates. Blank spaces in column I will remain as-is.
Here is the sample of the sheet:
A | B | C | D | E | F | G | H | I | J | K | L | M |
411101 | CONSUMABLES | 311199 | LIABILITIES | 700146 | 07/18 Bonded Store | IND / IDN | SRINIVAS | USD | -962.53 | 1 | -962.53 | |
411101 | CONSUMABLES | 311199 | LIABILITIES | 700147 | 7/18 BS PROFIT-3M KHO MARK ANG | USD | 84.56 | 1 | 84.56 | |||
411101 | CONSUMABLES | 311199 | LIABILITIES | 700150 | 7/18 BS-CREW SLOPCHEST | USD | -866.09 | 1 | -866.09 | |||
411101 | CONSUMABLES | 312211 | PAINT-HULL,DECK,ENG | 900114 | Reversal of voucherno: 900097 | B10180058 | USD | 1099.6 | 1 | 1099.6 | ||
411101 | CONSUMABLES | 312211 | PAINT-HULL,DECK,ENG | 930387 | 07/18 PO NOT SUPPLIED | B10180058 | USD | -1099.6 | 1 | -1099.6 | ||
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | -48.72 | 1 | -48.72 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 18.3 | 1 | 18.3 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 9.8 | 1 | 9.8 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 34.28 | 1 | 34.28 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 25.14 | 1 | 25.14 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 35.43 | 1 | 35.43 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 18.1 | 1 | 18.1 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 2.04 | 1 | 2.04 |
411101 | CONSUMABLES | 312221 | STORES-DECK | 210249 | DECK CONSUMABLE ORDER 2ND QUAR | xxxx SUPPLIERS | B10180068 | ***/0393/18-19 | USD | 22.9 | 1 | 22.9 |
<colgroup><col span="3"><col><col span="9"></colgroup><tbody>
</tbody>
Thank you very much for all your help.