Results 1 to 9 of 9

Thread: Unique Random Numbers Using Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-02-2014, 03:44 PM #3
    papabill
    papabill is offline
    Member
    Join Date
    Nov 2012
    Posts
    33
    Rep Power
    0
    In C1, type =RANDBETWEEN(1,31)
    in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
    Outstanding, thanks, but I see that there are several duplications. Any way to stop that?
    Last edited by papabill; 09-02-2014 at 03:56 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Random Unique Value Generator Based On Sample Size And Maximum Items Limit
    By bmbalamurali in forum Excel Help
    Replies: 3
    Last Post: 10-11-2013, 02:52 PM
  2. Random Numbers
    By DDon in forum Excel Help
    Replies: 3
    Last Post: 08-01-2013, 12:49 AM
  3. Unique Random Number In Ascending Order
    By marreco in forum Excel Help
    Replies: 8
    Last Post: 11-04-2012, 04:15 PM
  4. Random Unique Number Generator Excel VBA
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 10-18-2012, 01:00 PM
  5. Generate random numbers in Excel
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 10-06-2011, 11:24 AM

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