Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How to summary by ColumnA + ColumnB + ColumnC by VBA ?
Column B and ColumnC are unsorted columns. Column D is amount, need to summary. I prefer using array or collection be build a summary list. The number of data less than 1000 rows. Column A Column B ColumnC Column D 6321002974 61901990 010-BT 1,510.00 6321002974 61901990 010-BT 3,628.59 6321002974 61901990 010-BT 4,239.76 6321002974 61901990 010-BT 2,527.06 6321002974 61901990 010-BT 1,611.77 6321002974 61901990 010-BT (10,118.32) 6321002974 61901991 010-BT 4,163.95 6321002974 61901991 010-BT 2,081.97 6321002974 61901991 010-BT 2,081.97 6321002974 61901991 010-BT 2,079.46 6321002974 61901991 010-BT (2,081.97) 6321002974 61901991 010-BT (2,081.97) 6321002974 61901991 010-BT (4,163.95) 6321002974 61901991 010-BT (2,081.97) 6321002975 61000000 130-BT 240.89 6321002975 61000000 130-BT 1,180.70 6321002975 61100000 130-BT 16.86 6321002975 61100000 130-BT 177.18 6321002975 61100000 130-BT 58.96 6321002975 61100000 130-BT 7.19 6321002975 61100000 130-BT 101.16 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF value columnA columnB | Excel Worksheet Functions | |||
sum up columnA depending on conditions on columnB and columnC | Excel Discussion (Misc queries) | |||
Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
Delete row if columnA and ColumnB are same | Excel Programming | |||
Delete row if columnA and ColumnB are same | Excel Programming |