+ Reply to Thread
Results 1 to 2 of 2

Drag copying formula down while skipping cells in adjacent reference column

  1. #1
    Registered User
    Join Date
    02-02-2014
    Location
    Colorado
    MS-Off Ver
    Excel 2003
    Posts
    1

    Drag copying formula down while skipping cells in adjacent reference column

    Hello! I have a spreadsheet with temperature data, all in one column (D), that was recorded every 10 minutes for several months. In two adjacent columns (E & F), I would like to record the daily max and min temperatures. I can manually do this with MAX and MIN formulas in column E and F respectively, MAX(D1:D144). But when I copy this formula to the next row, I get MAX(D2:D145) when what I really want is MAX(D145:D288)....and so on...

    Any help appreciated!

    Jesse

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Drag copying formula down while skipping cells in adjacent reference column

    Starting in row1 try
    Please Login or Register  to view this content.
    and pull down as needed
    The same for the MIN function

+ 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. Drag and drop formula while skipping cells in the reference.
    By Carlos90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 05:57 PM
  2. How to drag a formula while skipping every other cell reference
    By sbham in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2013, 06:17 AM
  3. [SOLVED] Copying a formula down but skipping cells
    By dnsmc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2013, 03:05 AM
  4. [SOLVED] Drag/Fill column while skipping multiple reference rows in another worksheet
    By chandlerrw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2013, 07:59 PM
  5. Macro to drag fill 10000 rows with no left side adjacent cells to reference ?
    By Dale Saukerson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2012, 06:16 PM

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