| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate Item, months and volume
I can turn the dates to months in TABLE 1 with =text (b2;"mmm.yy"), but how
do I consolidate the Item, months and volume, so I get TABLE 2: TABLE 1 Item Date Volume A 01.04.2010 10 000 A 01.04.2010 10 200 B 01.04.2010 9 800 A 15.04.2010 10 500 B 01.05.2010 9 750 B 01.05.2010 10 150 A 01.06.2010 10 200 B 01.07.2010 9 850 TABLE 2 Item Month Volume A apr.10 30 700 B apr.10 9 800 B mai.10 19 900 A jun.10 10 200 B jul.10 9 850 -- Regards Tommy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate, Lookup and Sum from dates to months | Excel Programming | |||
| dictionary-(item, item, item); Can dictionary point to an array inVBA? | Excel Programming | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| How do I use a" item description" in excel to consolidate totals? | Excel Discussion (Misc queries) | |||
| Dates to months and calculating values for their months | Excel Programming | |||
Threaded Mode
