Results 1 to 26 of 26

Thread: [Resolved]]Excel formula - ignore zeros

Threaded View

  1. Jul 28th, 2010, 01:54 AM #1
    Pirate
    Pirate is offline

    Thread Starter
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083

    Resolved [Resolved]]Excel formula - ignore zeros

    I have like this data below :
    1
    2
    3
    4
    0
    6
    7
    8
    9
    10

    simply i need to completey ignore any zero and continue on from the above number .eg.:

    based on above data, after the zero , number 6 should be 5 (i have many zeros btw).

    Is it easy in excel ??

    Thanks
    Last edited by Pirate; Jul 30th, 2010 at 10:41 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width