+ Reply to Thread
Results 1 to 4 of 4

Serial Number in column leaving rows which has 0 amount

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    40

    Serial Number in column leaving rows which has 0 amount

    Hi There,
    I am not that good in excel. There is no doubt being new, I need your help indeed and I appreciat that. I have a worksheet of statment where two particular columns are serial number and amount. I would like to serial them in a way that the row under amount carries "0" should not carry a serial number but to the next.
    The sample file I have created i.e. A for serial number and C for amount
    - row 2nd does not have amount and 3rd does have amount therefore, 3rd row will carry 2 number in and 2nd has to leave either blank or 0

    Thank you very much and looking forward for your help
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Serial Number in column leaving rows which has 0 amount

    Try this in A2:

    =IF(C2=0,0,MAX($A$1:A1)+1) and copy down.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Serial Number in column leaving rows which has 0 amount

    Hi Soren,
    That's wonderful....it worked!
    Thanks a lot for your help.

  4. #4
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Serial Number in column leaving rows which has 0 amount

    You're welcome!

+ 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