random generator

Hello all, New to this forum and I haven't done Macros before. What I have done with excel is self-taught and therefore I would really appreciate your expertise. I am trying to build a random time generator that will give me 6 times a day. 3 times between 0600 and 1800, and 3 times between...

Hi folks Every year I have to generate a list of 4 digit safe codes, for 60 sites, that change monthly. The safe codes cannot have repeating characters. So I have 60 rows, 12 columns. Each cell must have a code between 0123 and 9876. They need to be randomly generated. It doesn't have to be...

Hi, I have a list of 20 values in excel. I want to pick four by a certain rule, which I have figured out. Now I want to pick 6 randomly from the remaining 16. I used 'randbetween' for the whole range of values (since I won't know ahead of time which 4 will be picked by the rules) along with a...

Dear All, I hope this has not been answered on this forums, I tried to search for a solution but have reached this far (see below code). The problem: I have sheet where i want to simulate a certain process. I generate random numbers and want to compare it for a value in a cell. Lets say i want...

Hi All, Quick question. I want to generate a list of random numbers each 125 digits long, including zeros, with a full output - not reduced to an E+ number. Excel seems to have limit on the RAND and RANDBETWEEN after about 17 digits. Any suggestions appreciated. Thanks,

I am trying to build DA6 form (military duty roster form) that uses excel, but takes into consideration a Soldier's weighted percentage that is based on a few variables such as number of times Soldier has done duty, if the duty was on the weekend, was the duty a priority 1 vs a priority 3, and...