+ 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
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  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
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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. 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