+ Reply to Thread
Results 1 to 16 of 16

Finding next available number with addition of Left function

Hybrid View

Samba1 Finding next available number... 07-02-2012, 05:23 PM
oeldere Re: Finding next available... 07-02-2012, 05:37 PM
shg Re: Finding next available... 07-02-2012, 05:46 PM
shg Re: Finding next available... 07-02-2012, 06:22 PM
Søren Larsen Re: Finding next available... 07-02-2012, 06:39 PM
shg Re: Finding next available... 07-02-2012, 06:44 PM
Samba1 Re: Finding next available... 07-02-2012, 07:27 PM
Samba1 Re: Finding next available... 07-02-2012, 07:55 PM
Søren Larsen Re: Finding next available... 07-03-2012, 03:45 AM
Samba1 Re: Finding next available... 07-03-2012, 01:24 PM
Søren Larsen Re: Finding next available... 07-03-2012, 01:56 PM
oeldere Re: Finding next available... 07-03-2012, 02:20 PM
Samba1 Re: Finding next available... 07-03-2012, 02:15 PM
Søren Larsen Re: Finding next available... 07-03-2012, 02:37 PM
Samba1 Re: Finding next available... 07-03-2012, 03:21 PM
Søren Larsen Re: Finding next available... 07-03-2012, 03:22 PM
  1. #1
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Finding next available number with addition of Left function

           -----A----- ------B------- C -----D------
       1     Number    W/ check digit   First Unused
       2   11242263959   112422639598    11242263965
       3   11242263960   112422639604               
       4   11242263961   112422639611               
       5   11242263962   112422639628               
       6   11242263963   112422639635               
       7   11242263964   112422639642               
       8   11242263966   112422639666               
       9   11242263967   112422639673               
      10   11242263968   112422639680
    In D2, confirmed with Ctr+Shift+Enter,

    =INT(INDEX(B2:B25, MATCH(TRUE, INT(B3:B25/10) - INT(B2:B24/10) > 1, 0))/10) + 1
    Last edited by shg; 07-02-2012 at 06:40 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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