Results 1 to 7 of 7

Incremental cell block (A1+2 = A3.....is it possible ???)

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Incremental cell block (A1+2 = A3.....is it possible ???)

    For example, I have a data like this :

    A B C
    1 Brad Judith A1+2=A3
    2 Emile Carmen A3+2=A5
    3 Judith Agustine A5+2=A7
    4 Philip Chris A7+2=A9
    5 Carmen
    6 Mark
    7 Agustine
    8 Mike
    9 Chris
    10 Merry


    The result supposed to be like in column B (I wrote the formula like in column C, but it give me #VALUE)
    Because the data is so many, It take hours to do manually.... is there a way ?

    Any suggestion ?

    Many thanks !
    Attached Images Attached Images
    Last edited by tanangc; 10-29-2012 at 08:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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