Crate Non volatile random list

[Dicken]

Hello,
  Is there a way to create a fixed random list of numbers;   so example ; 

                 List.Transform( List.Repeat({1} ,20 ) , (x)=>
                                     Number.Round( Number.RandomBetween(1,20 ),0))

  that will not change when refreshed, other thant loading to excel copy past values re load? which means I may as well have just done it in excel. 

Richard

[adudani · Accepted solution]

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]

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.