|
|
#6
08-14-2021, 04:03 AM
|
||||
|
||||
If you need to know the lowest Or. No used in a pad (you didn't ask for it in your narrative but did in your sample file) you may need a tweak to the formula I gave for that to:
=MINIFS(Table1[OR No.],Table1[OR No.],">=" & FLOOR(Table1[@[OR No.]]-0.1,50)) this is to cater for when the Or. No. was an exact multiple of 50. 
|
|
|
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