Subtotals in Excel 2007

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

A1 contains the column heading "NAME"
A2 thru A700000 contain names (each name can occur 1 thru 25 times).

B1 contains the column heading "AMOUNT"
B2 thru B700000 contain amounts

In the SUBTOTALS dialog box:
In the "AT EACH CHANGE IN" box, I select NAME
In the "USE FUNCTION" box, I select SUM
In the "ADD SUBTOTAL TO" box, I click NAME and AMOUNT

When I click OK, why does it take at least several HOURS to compute
the subtotals for the 80,000 unique names? How can I speed up the
process?
 
I don't think you can speed up the process if indeed you have 700,000 rows
with data.
I would use Access or some other database for a task like this.

You could try to see if a pivot table would be faster, put the name header
in the row field and the amount header in the data field.


--


Regards,


Peo Sjoblom
 
Back
Top