coconutwei
New Member
- Joined
- Jun 28, 2008
- Messages
- 5
CUST | PRODUCT | PACKING | DATE | QTY | 1/14 | 2/14 | 3/14 | 4/14 | 5/14 | 6/14 | 7/14 | 8/14 |
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | Jan-14 | 2 | ||||||||
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | Feb-14 | 1 | | |||||||
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | Feb-14 | 1 | ||||||||
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | Mar-14 | 2 | ||||||||
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | Apr-14 | 1 | ||||||||
PBMW02 | ACCU CHEK ADV 2 STRIP | 25'S | May-14 | 2 | ||||||||
PBMW02 | ACUGESIC TAB 50MG (BLIS) | 10X10'S | Jan-14 | 1 | ||||||||
PBMW02 | ACUGESIC TAB 50MG (BLIS) | 10X10'S | Jul-14 | 1 | ||||||||
PBMW02 | ADROTEN 5MG TAB | 10X10'S | Jan-14 | 1 | ||||||||
PBMW02 | ADROTEN 5MG TAB | 10X10'S | Apr-14 | 1 | ||||||||
PBMW02 | ALATROL TAB 10MG (W) | 10X10'S | Jan-14 | 5 | ||||||||
PBMW02 | ALATROL TAB 10MG (W) | 10X10'S | Jan-14 | 5 | ||||||||
PBMW02 | ARCOXIA 90MG TAB | 10X10'S | Apr-14 | 1 | ||||||||
PBMW02 | ARISONE CREAM 1% | 50G | May-14 | 2 | ||||||||
PBMW02 | ARISONE CREAM 1% | 50G | Jul-14 | 5 | ||||||||
PBMW02 | ASTHALIN INHALER | 200D | Feb-14 | 5 | ||||||||
PBMW02 | AT CHLORPYRIMINE INJ 10ML | 1VL | Jan-14 | 5 | ||||||||
PBMW02 | AT CLOFEC INJ 75/3ML | 50AMP | Feb-14 | 0 | ||||||||
PBMW02 | AT DEXASONE INJ 5MG/ML | 50AMP | Jul-14 | 0 | ||||||||
PBMW02 | AT DEXASONE TAB | 50X10'S | Jan-14 | 2 | ||||||||
PBMW02 | AT DEXASONE TAB | 50X10'S | Feb-14 | 1 | ||||||||
PBMW02 | AT DEXASONE TAB | 50X10'S | Jul-14 | 2 | |
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
.
.
Greeting to all the Excel Programming Expert,
Long time ago, I received some helps on Excel formula here. I thanks them.
Today, while I was doing this, I thought of this forum, and I believed there must be something that can be done.
Above is spreadsheet of what I am currently doing.
I have a very large database of invoices, and I was asked to put the ordered quantity into each column of Month/Year.
What I am currently doing is, I manually type one by one, but I believe there must be something can be done to ease this pain. (For your info, there are around 40k of records)
I appreciate if anyone can tell me if there is a formula to be used.
The complexion of this is beyond my Excel knowledge.
What I need is,
- If the buyer bought the item on Feb, Mar, Apr, with 1-1-2 each, then the column below 2/14, 3/14, 4/14, will appeared with number 1,1,2 each.
- If there are 2 purchases over the same item on the same month, assuming Apr, 2+2, then the column will display 1,1,4 each.
Thanks in Advanced,
Coconutwei