One good, quick way - Use a pivot. It'll deliver exactly what you seek, in a
matter of seconds, and despite the voluminous data
Create a pivot (click DataPivotTable), then in step 3 of the wizard, click
Layout, drag n drop "Account ID" into ROW area, "Amount" into DATA area
(it'll show as Sum of Amount). Click OK Finish. That's it. Hop over to the
pivot sheet for the amazing results delivered: a listing of all the unique
Account IDs in a column with their corresponding sums next to it
Wave your success here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"tenny" wrote:
Here is an example of the data I have.
Account ID Amount
101567 $505.00
101567 $875.00
101567 $2,450.50
253570 $1,178.90
253570 $875.00
346677 $1,928.33
I have thousands of accounts with multiple amounts having the same ID and I
need to add these amounts and combine them so that there is only one row per
account ID. Please help...