+ Reply to Thread
Results 1 to 4 of 4

Creating Unique Number Sequence

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    LA, Cali
    MS-Off Ver
    2008 Mac
    Posts
    20

    Creating Unique Number Sequence

    Hi forums!

    I have a quick question:

    Is there a way to automatically continue a number sequence like this?

    1/1
    1/2
    1/3
    1/4
    1/5
    1/6
    ... you get the idea. I'd like it to go to -- I guess 1000 is enough.

    I seem to get random auto-fills. Like 1/1 gives me 1-jan - and other custom formats to numbers just go bizarre when I try to extend them downwards.

    Thanks

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Creating Unique Number Sequence

    Maybe something like this?

    ="1/"&ROWS($A$1:A1)

    A
    1
    1/1
    2
    1/2
    3
    1/3
    4
    1/4
    5
    1/5
    6
    1/6
    7
    1/7
    8
    1/8
    9
    1/9
    10
    1/10
    11
    1/11
    12
    1/12
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    09-24-2014
    Location
    LA, Cali
    MS-Off Ver
    2008 Mac
    Posts
    20

    Re: Creating Unique Number Sequence

    I'll give it a whirl.

  4. #4
    Registered User
    Join Date
    09-24-2014
    Location
    LA, Cali
    MS-Off Ver
    2008 Mac
    Posts
    20

    Re: Creating Unique Number Sequence

    Perfect! Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating an ascending number sequence in groups of 6
    By chakotay in forum Excel General
    Replies: 11
    Last Post: 10-03-2016, 01:37 PM
  2. Creating Number Sequence in Groups of 10
    By DBWalsh12 in forum Excel General
    Replies: 8
    Last Post: 02-21-2013, 05:55 PM
  3. Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  4. unique number sequence
    By stormrider in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-05-2007, 02:25 PM
  5. Macro for a unique sequence number
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2005, 08:45 PM

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