Random value generation
Excel might have a built-in function for generating random values.
Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".
-This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
-The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).
Peter Szmodics commented
Thank you for the comment.
The purpose of this function is to substantially shorten the time needed to formulate the criteria.
Instead of combining the functions 'IF' and 'RAND' casewise, you can use this recommended predefined function.
The 'RAND' function is still part of the solution, but the user could immediately apply the criteria without further effort.
Not sure why this is better than applying the existing =RAND() function.