Extremely sloooooooooow subtotalling

G

gary

My spreadsheet looks like this:

parcel type tax penalty cost
123 0000 10.00 1.50 30.00
234 2345 5.55 .55 10.00
356 5040 11.11 1.12 3.00
945 2145 7.00 .70 1.50

(My spreadsheet has 135,000 different parcels)

When the parcel changes, I need subtotals for the tax, penalty and
cost.

After 30 minutes, subtotals have been inserted for only 15,000
parcels. At this rate, it'll take almost 5 hours to complete.
Is there any way to speed up the subtotalling?
 
G

gary

Hi Garry,

About 6 hours ago, I posted my original message here (in the MISC
group) but, a few minutes later, I removed it and posted it in the
PROGRAMMING group.

Gary
 
G

GS

gary laid this down on his screen :
Hi Garry,

About 6 hours ago, I posted my original message here (in the MISC
group) but, a few minutes later, I removed it and posted it in the
PROGRAMMING group.

Gary

I 'get it' but that doesn't remove postings when they've already been
downloaded to a newsreader. Most people who monitor these newsgroups
use a news reader rather than internet access.<g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top