Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extremely sloooooooooow subtotalling
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extremely sloooooooooow subtotalling
Oops! Multi-posted AGAIN, huh!!!!!
-- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extremely sloooooooooow subtotalling
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 On Jan 24, 10:27*pm, GS wrote: Oops! Multi-posted AGAIN, huh!!!!! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extremely sloooooooooow subtotalling
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 -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotalling | Excel Worksheet Functions | |||
Subtotalling | New Users to Excel | |||
Subtotalling | Excel Worksheet Functions | |||
Subtotalling | Excel Worksheet Functions | |||
subtotalling using vba | Excel Programming |