IF ONLY

brs2003 · Mar 21st, 2002, 07:53 AM

I have a spreadsheet which in some cases has duplicate entries (claim numbers)...Amount column does change (123 with $4.25, 123 with $1.25). I would like to write a macro which adds all $ with the same claim number and puts a summary information (123 WITH $5.50) under each claim series. My database has 10K records so using CLAIM SORT, SUB-TOTAL BY CLAIM ON AMOUNT would be very cumbersome. HELP !

[ This Message was edited by: brs2003 on 2002-03-21 06:55 ]

Mark W. · Mar 21st, 2002, 08:00 AM

Consider using a PivotTable.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 07:53 AM	#1
brs2003 New Member Join Date: Mar 2002 Posts: 1	I have a spreadsheet which in some cases has duplicate entries (claim numbers)...Amount column does change (123 with $4.25, 123 with $1.25). I would like to write a macro which adds all $ with the same claim number and puts a summary information (123 WITH $5.50) under each claim series. My database has 10K records so using CLAIM SORT, SUB-TOTAL BY CLAIM ON AMOUNT would be very cumbersome. HELP ! [ This Message was edited by: brs2003 on 2002-03-21 06:55 ]

Mar 21st, 2002, 08:00 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Consider using a PivotTable.