Results 1 to 4 of 4

Applying a formula to a large specific amount of cells in a column

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    Ontario, CA
    MS-Off Ver
    2010
    Posts
    45

    Applying a formula to a large specific amount of cells in a column

    I feel like this is a noob question but I can't figure it out and I was wondering if you guys can help me out.

    So I am basically doing a sum function for a row that has four columns. (a + b + c + d = sum in e)
    I know you can drag the highlighted square to go down and also you can us CTRL + SHIFT + END KEY (or DOWN ARROW) but the thing is the file is way too large for excel to handle. I found out I have a 32 bit excel program which limits the computing power of the program (company comp) which can't handle 750,000 + rows all at once and will crash or not be able to save. So the only thing I am trying to do is highlight every 20,000 rows and then adding the formula. Is there any quicker way of doing this? Such as I paste the formula where I can specifically say cells A1-A20,000 apply then after it computes do the next batch or so.

    Thanks!
    Last edited by alcorp; 07-03-2014 at 04:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 10-18-2019, 04:02 AM
  2. Applying the same formula to all cells in one column
    By seigna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2013, 07:17 PM
  3. [SOLVED] Applying a formula to triplicate samples with a large dataset
    By a_coe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-01-2013, 11:58 AM
  4. Find cells in a column that total specific amount
    By Donpa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2010, 08:16 PM
  5. Applying a Formula to an Extremely Large Column
    By joynerCN in forum Excel General
    Replies: 5
    Last Post: 01-05-2009, 08:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1