+ Reply to Thread
Results 1 to 8 of 8

Invoice Queue Sequence

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: Invoice Queue Sequence

    Obviously I did a terrible job trying to explain what I trying to do, so I start from scratch. I changed the A,B,C to a count to try to make more sense of it.

    The same invoice number could appear on the list for several days, and then get back on the list. In the example the file contains three invoice numbers.
    In the example, invoice # "1235" appears on the list on three consecutive date ranges. 1/5/17 - 1/6/17, which would get put in the queue for first time a -1 after the invoice #. Then on 1/11/17 it would be back in the queue as -2. And then again for 1/21/17 - 1/22/17 it would get a -3.

    Column E is intended to just illustrate the values of what column C should be. (There won't actually be a column E queue)

    PS... the formula I have in column C is clearly wrong, it was just my attempt at trying to get something to work.
    Attached Files Attached Files
    Last edited by Delta729; 11-11-2017 at 03:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create Unique Sequence Number in Cell for invoice
    By ioannisg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-14-2015, 10:08 PM
  2. [SOLVED] Check the Queue Number from column H in Sheet1 and change it to Queue Name
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2014, 06:12 AM
  3. Priority Queue
    By coachklein in forum Excel General
    Replies: 6
    Last Post: 11-03-2011, 06:05 PM
  4. Replies: 0
    Last Post: 09-23-2011, 01:00 AM
  5. [SOLVED] Navigating a Queue
    By John in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2006, 05:35 PM
  6. TRACK TIME THEN INVOICE WITH SEQUENCE
    By ed in forum Excel General
    Replies: 0
    Last Post: 06-22-2006, 10:50 PM
  7. EXCEL queue VBA
    By nomad815 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2005, 03:22 AM

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