The Random Generator add-in lets you quickly populate the selected cells with random records of any chosen type. With this tool, you can create random numbers without duplicate records, randomize values from your custom list, or obtain secure passwords.
So, pick your task and let's get started.
Run the add-in from the Randomize tool in the Utilities group on the Ablebits Tools tab:
You will see the Random Generator pane:
By default, the tool selects the entire data range in your sheet. You can change the range by choosing it in your table manually, entering the address into the range area using your keyboard, or by clicking the Expand selection icon (blue in the screenshot above) to get the whole table highlighted automatically.
To start adjusting the options, expand the group of interest on the Random Generator pane.
If you need random alphanumeric strings, codes, random text, or other string data, use the String section in the Random Generator pane.
Once I have installed the Random Number Generator feature can it be embedded into a PowerPoint presentation? I want to randomly generator (4) numbers, four different times during a presentation. I will have Wi-Fi access to the internet if needed.
Thank you for your question. I am sorry, but our add-in can't be run or embedded in any other application, except Excel.
25.020/25.052 this is the minimum and maximum specification how to put random formula in excel can you please give me a solution
Thank you for your question. Unfortunately, your task is not quite clear. Could you please describe it in more detail and email us a workbook with sample data you'd like to generate? We'll see if our software can help.
Does this product require an active connection to the Internet (once installed) to use it, or can I use it off-line where there is no Internet access? Thank you!
Thank you for your question.
Please note that the Random Generator tool is available as a part of Ultimate Suite for Excel. You need the Internet connection for downloading and activating the add-in. Internet access is not required for installing and using the tools.
Feel free to install Ultimate Suite in a trial mode and check how the tool works. Here is the direct download link for you:
If you have any questions or need some assistance with the add-in, please email us at firstname.lastname@example.org.
Is there a way to create a random unique strings? I'm trying to generate 3 millions codes with 5 digits (letters and numbers).
Also, Excel rows is limited to around 1 million, and I can't seem to remove duplicates spread over different columns. Is there a workaround for this?
Thank you for your question. Please try to select a range that contains more than 3 million cells, use Random Generator to fill them in with random strings, and apply the Find Duplicate Cells tool to eliminate duplicate entries. For detailed instructions on how to work with Find Duplicate Cells, please visit our help page.
If you have any other questions, feel free to email us at email@example.com
Thank you for your positive feedback. We appreciate your time in sharing it with us.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!