| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GROUP BY & SUB TOTAL - HOW to do it???
I have rows of data as below, I want to group by col 3 & col 4 then sub total
by col 5, how can I do this via macro VBA? 1 2 3 4 5 A 3000 PETER GBP -510.00 B 2500 SARAH USD -1000.00 C 1100 PETER GBP 502.00 D 560 CLAIRE USD 682.00 E 1885 PETER USD 6100.00 F 980 CLAIRE USD -1800.00 G 3220 SARAH EUR 699.00 H 6110 SARAH EUR -500.00 -- Thanks Sally |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for group total | Excel Discussion (Misc queries) | |||
| Group Total | Excel Discussion (Misc queries) | |||
| Need to total how many came from a particular group. | Excel Discussion (Misc queries) | |||
| Data Group Total | Excel Worksheet Functions | |||
| Data Group Total | Excel Worksheet Functions | |||
Threaded Mode
