Results 1 to 16 of 16

pick names at random

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    Houston
    MS-Off Ver
    Excel 2019
    Posts
    43

    pick names at random

    Im trying to make a pick names at random from a list on excel Column A to C. but I don't want them to repeat once they are chosen how do I do that? Or can it be done? I have this formula
    =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
    and also the column B shouldn't be selected by employee more than 2 people. what formula I used to stop selecting from more that 2 names on column B form column A
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to pick 3 random names from a list
    By philenty in forum Excel General
    Replies: 3
    Last Post: 11-15-2016, 09:00 AM
  2. pick a name out of list of 20 names without repeating names picked
    By gammoneer2b in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-06-2014, 10:14 AM
  3. uner what creteria random formulae pick up next random value?
    By roofi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2014, 12:55 AM
  4. Pick random names from list
    By ThomB in forum Excel General
    Replies: 3
    Last Post: 04-08-2013, 10:55 AM
  5. random pick names from a list
    By jladika in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2011, 05:31 PM
  6. Replies: 8
    Last Post: 08-14-2009, 11:22 AM
  7. random pick names from the list
    By jinvictor in forum Excel General
    Replies: 1
    Last Post: 06-26-2006, 10:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1