Forum Discussion

m_tarler's avatar
m_tarler
Silver Contributor
Jul 28, 2025

Re: Help with a formula

try

=TAKE(SORTBY(SEQUENCE(15),RANDARRAY(15)),5)

 

2 Replies

  • Frank3821's avatar
    Frank3821
    Copper Contributor
    Jul 29, 2025

    thank you..  I should have put my actual range...  I need between 25 & 75

    I'm not sure where to plug those values in to that formula..... 

    • m_tarler's avatar
      m_tarler
      Silver Contributor
      Jul 30, 2025

      try this:

      =TAKE(SORTBY(SEQUENCE(51,1,25),RANDARRAY(51)),5)

      so basically the SEQUENCE creates the array of all possible numbers (25-75 which is 51 numbers in 1 column starting at 25)

      then create a matching length array of random numbers using RANDARRAY

      then SORT the number list by that random array

      then TAKE the first 5