Results 1 to 9 of 9

I need a random number within a range, and not to duplicate the numbers in current list

Threaded View

jmeddaugh I need a random number within... 07-09-2013, 10:31 AM
tigeravatar Re: I need a random number... 07-09-2013, 12:40 PM
jmeddaugh Re: I need a random number... 07-09-2013, 12:43 PM
jmeddaugh Re: I need a random number... 07-09-2013, 12:47 PM
jmeddaugh Re: I need a random number... 07-09-2013, 01:18 PM
tigeravatar Re: I need a random number... 07-09-2013, 01:37 PM
jmeddaugh Re: I need a random number... 08-20-2013, 03:47 PM
tigeravatar Re: I need a random number... 08-20-2013, 04:11 PM
jmeddaugh Re: I need a random number... 08-20-2013, 04:19 PM
  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Wausau, Wisconisn
    MS-Off Ver
    Excel 2010
    Posts
    19

    I need a random number within a range, and not to duplicate the numbers in current list

    Hi all! Here is what I am doing. Our students have a alternate student number which is what they use for email, computer login, etc... the syntax is the first four numbers are 1010 and the last four are the variable...for example 10102342 is one student and 10102393 could be a another student. The range is 10100001-10109999. I currently have just under 1000 students with 1010#'s already, so I would like to create a button on a form that would generate a 1010xxxx number without duplicating the current numbers.

    screenshot.png

    Thanks in advance!!

    My form has a text box (txtGenerate) which is the output; where the 1010# should show up. A command button (cmdGenerate) which is where the user will interact and click the button to generate the 1010#..
    Last edited by jmeddaugh; 07-09-2013 at 10:48 AM.

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