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, 2022 in Others 441 views

## 1 answer to this question.

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(,))`
• 63,180 points

## 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

## How to use goal seek function in Excel user function?

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

## Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

## How to use VLOOKUP function in MS Excel

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

## Convert Rows to Columns with values in Excel using custom format

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

## Remove formulas from all worksheets in Excel using VBA

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

## Calculate monthly average from daily data without PivotTable

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

## Automate compound annual growth rate (CAGR) calculation

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