Forum Discussion

AdamArends's avatar
AdamArends
Copper Contributor
Feb 27, 2023

Non-Repeating random between per unique ID

Hello 

 

Per this solution (here), can it be brought into Access... The memory Limit of the machine means I cannot run the macro in Excel. It works on a limited number of records. 

 

Basically, for each line where the trans_id is the same, I need a non-repeating random number between 1 and 25 (e.g. 1000129 would have 4 unique numbers between 1 and 25).

 

 

Thanks

Resources