Results 1 to 6 of 6

Random List Selection w/No Duplicates

Threaded View

  1. 12-10-2007, 02:16 PM #1
    RDSProgrammer
    RDSProgrammer is offline
    Registered User
    Join Date
    06-25-2007
    Posts
    20

    Random List Selection w/No Duplicates

    I need to fill 5 cells with random selections from a named range (rgnItems) without any of the 5 cells containing duplicate values from the others.

    Is this possible with an Excel function?

    Right now I have a formula in each of the 5 cells that randomly selects a value from rgnItems, but of course I am getting duplicates sometimes across my 5 cells.
    Last edited by VBA Noob; 12-10-2007 at 02:24 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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