+ Reply to Thread
Results 1 to 3 of 3

Copying a formula problem

  1. #1
    Registered User
    Join Date
    12-02-2020
    Location
    Holland
    MS-Off Ver
    EXCEL 2016
    Posts
    2

    Copying a formula problem

    Hi All,
    I have a small question.

    Knipsel.PNG

    If I select A1 to A3 (example 1) and copy it to A4, the formula in A4 becomes =+C4 (example 2)

    How can I chance this so when I copy this the formula becomes =+C2 and not =+C4

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,824

    Re: Copying a formula problem

    Maybe try this in cell A1 and copy to A4, A7, etc.
    =OFFSET($C$1,(ROW()/3),0)

  3. #3
    Registered User
    Join Date
    12-02-2020
    Location
    Holland
    MS-Off Ver
    EXCEL 2016
    Posts
    2

    Re: Copying a formula problem

    This works great, thank you !!

+ 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. Copying formula between workbook problem
    By gjjh25 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2013, 08:56 AM
  2. [SOLVED] Problem with copying formula with selective cells
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2013, 03:01 PM
  3. [SOLVED] Another problem copying formula to column using VBA
    By AWM1966 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2012, 01:29 PM
  4. V-Lookup formula copying problem
    By adrian078 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2007, 04:22 AM
  5. Formula copying problem
    By ccgreenman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2007, 06:28 PM
  6. Problem with copying formula
    By jimbob in forum Excel General
    Replies: 3
    Last Post: 11-27-2005, 03:12 PM
  7. Problem copying and pasting formula
    By Arsenalguy in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 01:05 PM
  8. [SOLVED] Problem copying formula.
    By Robin Gray in forum Excel General
    Replies: 2
    Last Post: 09-06-2005, 09:05 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