Alternatives to Subtotal function in excel

0 votes
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?
Nov 10 in Others by Kithuzzz
• 20,660 points
33 views

1 answer to this question.

0 votes

In an unused column to the right put this formula in the second row and double-click the fill handle.

if(a2<>a3, sumifs(d:d, a:a, a2), text(,))
answered Nov 10 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
75 views
0 votes
1 answer

How to use goal seek function in Excel user function?

In the Microsoft Excel Object-Sheet1(Sheet1), we can ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
54 views
0 votes
1 answer
0 votes
1 answer

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
31 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
93 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
69 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
89 views
0 votes
1 answer
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
74 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP