+ Reply to Thread
Results 1 to 4 of 4

Add two consecutive numbers in a colum and repeat operation with the next two numbers

  1. #1
    Registered User
    Join Date
    09-15-2017
    Location
    Nottingham
    MS-Off Ver
    10
    Posts
    2

    Add two consecutive numbers in a colum and repeat operation with the next two numbers

    Hello,

    I've got a list of values in Colum A (from A1 to A18000). Colum B needs to be B1 = A1 + A2 ; B2 = A3 + A4; B3 = A5 + A6;

    That must be repeated for the 18000 values in Colum A so Colum B must end up with 9000 values.



    How can I do that?

    Thank you in advance.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,539

    Re: Add two consecutive numbers in a colum and repeat operation with the next two numbers

    One way:

    =SUM(OFFSET($A$1:$A$2,(ROWS($1:1)-1)*2,))
    Glenn



  3. #3
    Registered User
    Join Date
    09-15-2017
    Location
    Nottingham
    MS-Off Ver
    10
    Posts
    2

    Re: Add two consecutive numbers in a colum and repeat operation with the next two numbers

    Brilliant!
    Thank you very much for your help.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,539

    Re: Add two consecutive numbers in a colum and repeat operation with the next two numbers

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. Finding 5 consecutive numbers in a set of 7 numbers
    By Namejs in forum Excel General
    Replies: 13
    Last Post: 05-20-2015, 06:35 AM
  2. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  3. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 PM
  4. Replies: 1
    Last Post: 06-07-2006, 02:25 AM
  5. ranking a colum of numbers
    By Genchaos in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2006, 06:35 PM
  6. How can I do AND operation on two binary numbers in MS Excel?
    By Zuke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-13-2006, 08:35 AM
  7. How do I set up a formula to repeat 5 consecutive cells in a colum
    By jbsand1001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2005, 02:06 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