+ Reply to Thread
Results 1 to 2 of 2

Alphanumeric sequence list

  1. 11-12-2013, 04:10 PM #1
    Npcw
    Npcw is offline
    Registered User
    Join Date
    11-12-2013
    Location
    Lansdale,PA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Alphanumeric sequence list

    Trying to create an alphanumeric list to print on tickets.

    100A
    100B
    100C
    101A
    101B
    101C
    102A
    102B
    102C

    Really need help!!!!! Thanks
    Reply With QuoteRegister To Reply
  2. 11-12-2013, 10:40 PM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Alphanumeric sequence list

    welcome to the forum, Npcw. try:
    =100+FLOOR((ROWS(A$1:A1)-1)/3,1)&CHAR(65+MOD(ROWS(A$1:A1)-1,3))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Alphanumeric Sequence
    By donberino in forum Excel General
    Replies: 8
    Last Post: 08-15-2013, 06:22 AM
  2. Creating an alphanumeric sequence using a column that determines the sequence
    By csstewar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  3. Generating a 4 part Alphanumeric Sequence
    By Label-makers in forum Excel General
    Replies: 20
    Last Post: 06-06-2012, 07:54 PM
  4. Alphanumeric sequence
    By El Zorro in forum Excel General
    Replies: 7
    Last Post: 04-29-2011, 09:57 PM
  5. Create an alphanumeric sequence
    By footsoreaxe in forum Excel General
    Replies: 11
    Last Post: 11-25-2009, 02:51 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1