+ Reply to Thread
Results 1 to 2 of 2

Rotating list without repeating numbers

  1. #1
    Registered User
    Join Date
    12-15-2013
    Location
    Texas, United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Rotating list without repeating numbers

    I need to make a list that has 90 people and each day I need it to pick 4 random people. I need it to keep rotating people daily for the entirety of the monthfrom the first day of the month without utilizing the same people over again. I've seen it before can I please please have help. I not excel savy at all so I need it dummy proof

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Rotating list without repeating numbers

    Let's assume that your 90 names are listed in column A starting from A2 downwards.
    Put in B2 formula:
    Please Login or Register  to view this content.
    and copy it down
    then put in C2 formula:
    Please Login or Register  to view this content.
    and also copy it down.
    You will get list of the 90 names in random order.
    You can copy this list and PasteSpecial as values only somewhere (say column D and pick every day 4 persons)
    It is important to paste special, because otherwise the list will change after each recalculation of the spreadsheet.

    See the attached file.
    Zeszyt1.xls

+ 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. Rotating Roster List
    By specialkmp in forum Excel General
    Replies: 1
    Last Post: 09-08-2012, 05:45 AM
  2. Random numbers without repeating comparing with previus list
    By perera13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2009, 09:49 PM
  3. [SOLVED] Rotating page numbers
    By Sach in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 10:40 AM
  4. Replies: 1
    Last Post: 06-06-2006, 02:35 AM
  5. Replies: 0
    Last Post: 06-05-2006, 07:15 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