large amounts of rows

  1. L

    Sheet with VERY LARGE data sets and complex formulas.

    I'll start with my question, first. What operations tend to bog excel down, and how can I speed up handling of very large data sets? My circumstances are as follows: I have several sheets, each of which are upward of 10K rows and 20 columns, but one of which is over 60K rows. These are...
  2. B

    VBA to Calculate Median/Average of 134,000 Rows (Separated by Hundredths of a Second)

    Hi All, I have a spreadsheet with 134,000 rows. Each row contains data from a hundredth of a second (1343 seconds total). Each hundredth of a second has several points of data that was recorded. What I would like to do is, summarize the data by second. (Average & Median of each Data 1, Data 2...
  3. D

    VLOOKUP across 700K rows in 32-bit Excel

    I can't apply a simple VLOOKUP across the data set I'm working with because it's so large (700K rows). I'm working out of a 32-bit excel and it's the only version I have access to. I've saved the file as an .xlsb to try to save space, but that didn't help much. I have to apply the formula to a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top