|
|
#1
08-11-2021, 11:26 PM
|
||||
|
||||
Last number issued in an invoice pad
This is related to my previous post.
A data sheet contains a list of invoices issued by several staff. If Ms. Alpha (I3) issued invoices numbered 6387127 to 6387132 (defined name, OR_No.), I would like the formula in K3 to return 6387132 which is the last serial number issued by Alpha from this invoice pad of 6387101 to 6387150. The first number issued during the month was 6387127, manually entered in J3. It is possible that a staff may be in charge of more than one invoice pad. I do not know how to include in the MAXIFS formula the booklet criteria. I have attached a sample sheet for more details. Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automated excel invoice clearing and saving invoice | sunboy | Excel | 2 | 09-25-2019 12:27 PM |
| Add a serial number to an invoice | pringle747 | Excel Programming | 6 | 02-19-2015 11:19 AM |
| Auto Generate Invoice Number Word 2013 | Jonah245 | Word VBA | 3 | 09-04-2014 05:24 PM |
| Invoice number sync from different location? | lbf200n | Excel Programming | 0 | 04-10-2013 06:55 PM |
 Invoice Number Generation
|
mrphilk | Excel | 2 | 06-08-2010 12:39 PM |
Windows 10 
Office 2019
Threaded Mode