+ Reply to Thread
Results 1 to 4 of 4

Adjust formula to add 6 instead of 1 for each row?

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Sandefjord, Norway
    MS-Off Ver
    Office 365 Business
    Posts
    30

    Adjust formula to add 6 instead of 1 for each row?

    I want the formula to add +6 for each row, for example =C5, then =C11, =C17, =C23 / =CONCATENATE(C6;D6), =CONCATENATE(C12;D12) =CONCATENATE(C18;D18) and continuing. Is this possible?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    28,881

    Re: Adjust formula to add 6 instead of 1 for each row?

    Try this:

    =CONCATENATE(OFFSET($C$6,6*(ROWS(H$6:H6)-1),,,),OFFSET($D$6,6*(ROWS(H$6:H6)-1),,,))

    see sheet. Adjust the H6 bits to suit wherever you start this list (keeps it working if/when you delete rows/columns)
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Sandefjord, Norway
    MS-Off Ver
    Office 365 Business
    Posts
    30

    Re: Adjust formula to add 6 instead of 1 for each row?

    Thank you Glenn Kennedy! Worked perfectly!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    28,881

    Re: Adjust formula to add 6 instead of 1 for each row?

    You are welcome.

+ 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. [SOLVED] How to adjust row height of row so tall the point to grab to adjust auto falls below
    By juntjoo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-22-2016, 02:07 PM
  2. Adjust the countif formula
    By tantcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 02:12 PM
  3. [SOLVED] Help to adjust date formula
    By scudo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 05:45 AM
  4. [SOLVED] Auto Adjust Stacked Column Need to Adjust Legend
    By tbren in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 01:56 PM
  5. How to adjust IF formula to different cells?
    By jgomez in forum Excel General
    Replies: 4
    Last Post: 05-19-2011, 05:36 PM
  6. adjust logarithmic scale + adjust chart
    By voltaire101 in forum Excel General
    Replies: 5
    Last Post: 08-05-2010, 08:12 PM
  7. Adjust rent increase through calendar, can excel adjust numbers itself?
    By divashenko@yahoo.com in forum Excel General
    Replies: 1
    Last Post: 01-16-2009, 05:31 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