| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for missing invoice numbers
Hi All, Firstly thanks for taking the time to look at this post. The problem I have is relating to invoices. I have an Excel spreadshee which I write down all payments I make for invoices. The invoice number are always a number and started at 1 and then increment by 1. IE 1, 2, etc. What I would like to do is to have a way in which I could look in m sheet to see if I have any invoices missing. ie 6 and 8 is there but is not. Due to the nature of invoices they are not always in order so I migh pay 9 before I pay 8 and therefore on my spreadsheet they wont be i order. they are currently in order of when I paid them. Would anyone know a way I could do this? Many tnaks agai -- luxbo ----------------------------------------------------------------------- luxboy's Profile: http://www.excelforum.com/member.php...fo&userid=2478 View this thread: http://www.excelforum.com/showthread.php?threadid=38345 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Missing invoice numbers from a sequence. | Excel Discussion (Misc queries) | |||
| Invoice Numbers | Excel Discussion (Misc queries) | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
| missing invoice toolbar when save customised invoice | New Users to Excel | |||
| Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
Threaded Mode
