Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
1 year ago
Solved

Crate Non volatile random list

Hello,   Is there a way to create a fixed random list of numbers;   so example ;                   List.Transform( List.Repeat({1} ,20 ) , (x)=>                                      Number.Rou...
Need Help
Show and Tell
  • adudani's avatar
    adudani
    1 year ago

    Hi Dicken ,

     

    If you specify a random seed, the List.Random numbers generated should be the same regardless of refresh.

     

    let me know if I understood the query

adudani's avatar
adudani
Memorable Member
1 year ago

Hi Dicken ,

 

If you specify a random seed, the List.Random numbers generated should be the same regardless of refresh.

 

let me know if I understood the query

Dicken's avatar
Dicken
Post Prodigy
1 year ago

As I understand List.Random generates a list of numbers between 0 and 1 , 
I want say whole numbers between 1 and 100 , or whatever, so in excel randaray; 
=RANDARRAY(20,1,1,100,TRUE)  , copy, paste values. 
Richad.