+ Reply to Thread
Results 1 to 5 of 5

RANDBETWEEN dates with no duplicates

  1. 03-07-2020, 02:37 PM #1
    focalfox
    focalfox is offline
    Registered User
    Join Date
    05-11-2016
    Location
    Kuala Lumpur
    MS-Off Ver
    2007
    Posts
    6

    RANDBETWEEN dates with no duplicates

    Hi,

    I would like to create a revision timetable for my daughter between 8 march 2020 and 30 oct 2020. There are 7 subjects involved with two to three papers for each subject, and 4 to 6 sets of questions for it. The idea is to have one set of question for each different day between the dates above, and selected day must be during weekdays and no weekends. I tried using randbetween guides from here but I was stuck with duplicates. I have here my working for review. Appreciate if anyone could explain where I went wrong or how to solve this. Thank you very much to all
    Attached Files Attached Files
    Last edited by focalfox; 03-07-2020 at 03:27 PM.
    Reply With QuoteRegister To Reply
  2. 03-07-2020, 02:57 PM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: RANDBETWEEN dates with no duplicates

    with RAND() and RANK
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-07-2020, 03:03 PM #3
    focalfox
    focalfox is offline
    Registered User
    Join Date
    05-11-2016
    Location
    Kuala Lumpur
    MS-Off Ver
    2007
    Posts
    6

    Re: RANDBETWEEN dates with no duplicates

    Quote Originally Posted by tim201110 View Post
    with RAND() and RANK
    Thanks for the solution, and how do i skip saturdays & sundays from this? Thanks again
    Reply With QuoteRegister To Reply
  4. 03-07-2020, 03:08 PM #4
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: RANDBETWEEN dates with no duplicates

    g5=CHOOSE(WEEKDAY(G4,2),1,1,1,1,3,2,1)+G4 and down
    Reply With QuoteRegister To Reply
  5. 03-07-2020, 03:23 PM #5
    focalfox
    focalfox is offline
    Registered User
    Join Date
    05-11-2016
    Location
    Kuala Lumpur
    MS-Off Ver
    2007
    Posts
    6

    Re: RANDBETWEEN dates with no duplicates

    Quote Originally Posted by tim201110 View Post
    g5=CHOOSE(WEEKDAY(G4,2),1,1,1,1,3,2,1)+G4 and down
    there is so much more to explore in excel. i still dont know how choose() & weekday() works but that solved my problem. only need to change the last date row to 174 to match 30 Oct 2020
    Thank you very much tim201110
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. RandBetween - No Duplicates in Column
    By stewarttracy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2018, 04:36 PM
  2. Reverse Raffle setup: using Randbetween without duplicates
    By msauer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2018, 05:35 PM
  3. Separation of duplicates with RANDBETWEEN
    By wyturieowk in forum Excel General
    Replies: 1
    Last Post: 04-30-2017, 03:18 PM
  4. [SOLVED] Randbetween with No Duplicates
    By novice1239 in forum Excel General
    Replies: 6
    Last Post: 03-19-2017, 10:17 AM
  5. How do you avoid duplicates when using the randbetween function?
    By Monica in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2014, 02:07 AM
  6. Randbetween without duplicates
    By Williamdry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2014, 09:27 AM
  7. [SOLVED] =RANDBETWEEN Function for growing price list with no duplicates...
    By unclejemima in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 03:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1