Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default How to summary by ColumnA + ColumnB + ColumnC by VBA ?

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF value columnA columnB Neffa Excel Worksheet Functions 5 August 13th 08 06:57 AM
sum up columnA depending on conditions on columnB and columnC pooposa Excel Discussion (Misc queries) 4 August 5th 06 01:52 AM
Count cells that contain "Y" in columnA IF contains"X" in columnB holliedavis Excel Worksheet Functions 6 July 20th 06 06:12 PM
Delete row if columnA and ColumnB are same Lillian[_5_] Excel Programming 4 June 11th 04 12:17 AM
Delete row if columnA and ColumnB are same Lillian[_5_] Excel Programming 0 June 10th 04 04:26 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"