+ Reply to Thread
Results 1 to 3 of 3

create custom auto fill formulas in Excel 2010

  1. #1
    Registered User
    Join Date
    04-01-2016
    Location
    gulf coast
    MS-Off Ver
    office 2010
    Posts
    2

    create custom auto fill formulas in Excel 2010

    My previous experience with Excel is limited to creating worksheets and manually entering data. Today I have learned to create formulas for individual cells and contiguous cells. I have spent most of the day researching and experimenting with creating custom auto fill formulas for a spreadsheet I have been updating manually --- with absolutely no success.

    Please see attached file as a sample of what I wish to accomplish. The entries in columns L and M have been created by formulas unique to each cell. My goal is to auto complete columns L and M after each row of data is entered. My problem lies in the fact that the most recent data in columns L and M are not in the same row as my most recent entries. Columns H thru K contain the data to be used in the formulas. My goal is to create two formulas (one each for columns L and M) to perform the appropriate addition/subtraction operations and auto fill these two columns.

    Any useful hints or help will be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: create custom auto fill formulas in Excel 2010

    Try

    L6=IF(AND(H6="",I6="",J6="",K6=""),"",LOOKUP(10^10,$L$5:L5,$L$5:L5)+SUM(H6:K6)) and drag down.

    M6=IF(AND(J6="",I6=""),"",LOOKUP(10^10,$M$5:M5,$M$5:M5)+J6+I6) and drag down.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    04-01-2016
    Location
    gulf coast
    MS-Off Ver
    office 2010
    Posts
    2

    Re: create custom auto fill formulas in Excel 2010

    Thanks Ankur,
    I tried to copy/paste/drag both formulas from your post to the worksheet with the same results. The formulas were copied down the columns without calculating and entering any values. Did I do something wrong?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto fill decimal sequence using custom fill or formula
    By 8cats in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2013, 08:53 AM
  2. Excel 2010 - Custom Macro that scales a print range to fill the page
    By barnett2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 04:53 PM
  3. Auto Fill, Excel 2010
    By msmonicadoll in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2013, 02:34 PM
  4. Excel 2010 formulas are not auto-populating
    By JAPbach in forum Excel General
    Replies: 3
    Last Post: 12-17-2012, 12:16 AM
  5. how to create a custom auto fill sequence
    By lix333 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-06-2012, 09:40 PM
  6. [SOLVED] Custom formulas with icons in conditional formatting in Excel 2010
    By Vinniel in forum Excel General
    Replies: 2
    Last Post: 09-24-2012, 09:20 AM
  7. microsoft excel 2010 auto fill date
    By stang56 in forum Excel General
    Replies: 8
    Last Post: 06-05-2012, 01:59 AM
  8. [SOLVED] How do I create custom fill colors (for cells) in Excel 2002?
    By rob653 in forum Excel General
    Replies: 2
    Last Post: 06-12-2005, 11:05 AM

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