I need to total of 36,892 records, which I have to do. Excel crashes when I try to utilize the subtotal function because it can't handle the volume of data.
I need to put the data in column d for each update in column an in my 36,000 rows of data. Column a contains 1 to 10 duplicate records, depending on the case.
I've tried dividing it up into smaller data chunks, but it seems to only be able to handle roughly 5,000 at a time, which will take forever.
Is there another choice I could make?