Results 1 to 5 of 5

Auto Sequencing to skip Negatives

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Auto Sequencing to skip Negatives

    I've attached a sample of my worksheet. I'm trying to write an auto number for column E "Receipts" to skip rows where receipts are not available, in which case want to display "No Receipt." Let's say Row 6 (Computer Repair) does not have a receipt. Instead of auto generating the auto number for that record as "03", can the auto number skip that record and continue to the next record and generate the next record as "03"?

    Is it possible for Excel auto numbering to skip negatives? If so, a true/false column would be needed but how to write the IF or OR function would be a total guess for me.

    If I'm already using IF(ISBLANK,"" , would I be able to add another function to display "No Receipt"? I've tried different variants of functions and in the end it's just logical to think that anything I put after IF(ISBLANK,"" would contradict each other.

    I think my best bet is to reconfigure the whole sheet. Any help would be greatly appreciated. Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you skip a row when auto dragging a formula?
    By gmatula89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2013, 01:08 PM
  2. Excel Quotation template that requires auto sequencing serial number
    By johnnysiphone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2012, 04:18 PM
  3. Auto-Sequencing Down a Column FC0001 to FC0500
    By Bradlington in forum Excel General
    Replies: 3
    Last Post: 11-05-2008, 08:19 PM
  4. Auto calculate & line skip
    By Attila in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-09-2007, 06:10 AM
  5. using auto fill, but need to skip every 13th number
    By gotzoom in forum Excel General
    Replies: 3
    Last Post: 01-19-2006, 10:35 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