+ Reply to Thread
Results 1 to 4 of 4

Indirect formula change for row / column dragging

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Indirect formula change for row / column dragging

    Good evening, I need your help to modify the formula that you find in the attached file D5 Rep sheet
    to have the same result by putting it in cell D18 (yellow)
    and drag right and down.
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Indirect formula change for row / column dragging

    Please try at D18:G24


    =INDIRECT($L$5&"!R"&4+ROWS(D$18:D18)&"C"&2+COLUMNS($D18:D18),)

    4 is 1 row before data
    2 is 1 column before data

    Custom Format F18:G24 to hh:mm;;
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: Indirect formula change for row / column dragging

    Hi,Bo
    it works
    a question why we use R and C '
    R "& 4 + ... R = Rows
    C "& 2 + ... C = Columns?
    thanks always for your precious help

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Indirect formula change for row / column dragging

    This is R1C1 system
    https://bettersolutions.com/excel/fo...1-notation.htm

    R5C3 => C5

    R6C4 => D6

+ 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. Dragging down formula but making column change
    By mmarino121 in forum Excel General
    Replies: 5
    Last Post: 01-03-2020, 01:45 PM
  2. [SOLVED] How to change column letter in formula while dragging down?
    By archvanarl in forum Excel General
    Replies: 5
    Last Post: 02-21-2019, 05:21 AM
  3. Replies: 16
    Last Post: 09-29-2015, 01:06 AM
  4. Problems dragging down Indirect formula referring to a range
    By _hs_ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-26-2013, 08:09 AM
  5. Change column reference while dragging formula vertically
    By ekatecohn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2013, 07:23 PM
  6. When dragging a formula horizontally, how to change row instead of column?
    By Aderbalito in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2013, 10:44 PM
  7. Dragging down Indirect Formula
    By MROMAR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-22-2012, 10:33 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