+ Reply to Thread
Results 1 to 4 of 4

Google Sheets - Generating a Sequential list based on previous values

  1. #1
    Registered User
    Join Date
    05-14-2018
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    2

    Google Sheets - Generating a Sequential list based on previous values

    Hi,

    I am trying to generate a unique ID in Google Sheets.

    The structure of the unique ID is the following:

    2x Letter values (A-Z)+ 2x Digit values (18,19 or 20) + 2x Alphanumeric (A1,A2...Z9).

    With the above, an example unique ID will look like this: GB18A1

    I would like the last 2 alphanumeric characters to be generated in sequence (A1, A2.. A9, B1, B2.. B9...) and taking into account previous 4 characters, since the sequence is dependent on the first 4 characters and does not run independently.

    So, when someone is creating a new ID with first 4 characters being LD18, sequence will start from A1. Next time some creates an ID with LD18 as first 4 characters, A2 will be spit out. But if first 4 characters are changed, sequence will have to start from A1 again.

    I am unable to post a link but will do so if it's required (my forum access rights do not allow me to post links yet)

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,799

    Re: Google Sheets - Generating a Sequential list based on previous values

    Quote Originally Posted by lalalalalala View Post
    ... (my forum access rights do not allow me to post links yet) ...
    But you can attach a workbook - see the yellow banner at the top of the screen for details of how to do this.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-14-2018
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Google Sheets - Generating a Sequential list based on previous values

    Thank you Pete. Attached the sheet.
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,799

    Re: Google Sheets - Generating a Sequential list based on previous values

    I'm just about to log out now and go to bed, as it is past 2:15 am here. I'm out for most of tomorrow as well, so I'll have to pick this up in the evening, unless someone else can chip in.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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