+ Reply to Thread
Results 1 to 4 of 4

Increment count by from the previous count only when there is a value

  1. #1
    Registered User
    Join Date
    08-03-2006
    Posts
    60

    Increment count by from the previous count only when there is a value

    Hello Guys,

    This is probably simple and tried to find this in the forum, though not tried hard.

    Please Login or Register  to view this content.
    I want only the column A to be incremented by 1 from the previous count of Column of A ONLY when there is a value in Column F while disregarding values in other columns.

    Please help me in getting this.

    Thank You !

    Dhruva.
    Last edited by Dhruva101; 01-15-2009 at 12:49 AM.

  2. #2
    Registered User
    Join Date
    12-30-2008
    Location
    Vermont, USA
    MS-Off Ver
    Excel 2003
    Posts
    64
    if column F does not have a value, do you want a blank in column A or do you want the previous value in column A repeated?

    if you want Col A blank when F is blank:

    =IF(ISNUMBER(F2),MAX(A$1:A1)+1,"")

    if you want the previous value from Col A repeated when F is blank:

    =IF(ISNUMBER(F2),MAX(A$1:A1)+1,MAX(A$1:A1))

    Both of these are intended to be entered in cell A2 and filled down.

  3. #3
    Registered User
    Join Date
    12-15-2008
    Location
    Singapore
    Posts
    38
    If you want the previous value from Col A repeated when F is blank, you may also try this formula for A2:

    =IF(ISNUMBER(F2),A1+1,A1)

    Drag and fill down for the rest of the cells in column A.

  4. #4
    Registered User
    Join Date
    08-03-2006
    Posts
    60
    Thank you Clownfish and Ikuogs.

    FYI - I wanted blanks on A cells when there is no value on F cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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