How to generate only random even or odd numbers in Excel?
In this tutorial, I will introduce some formulas to help you generate only random even numbers or only random odd numbers in Excel.
Insert Random Data （insert random integer, date, time, string or custom list in a range.）
Here is a formula in Excel can only randomize even numbers.
Select a blank cell, and type this formula =EVEN(RANDBETWEEN(X,Y)) (X and Y indicate any integer numbers, and X<Y), for instance, I want to randomize even numbers between -5 and 10, now I type =EVEN(RANDBETWEEN(-5,10)) into an empty cell, press Enter key, if you need, you can drag the fill handle to a range with this formula.
To only randomize odd numbers in Excel, you can do as this:
|Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group |
as auto text, and liberate your brain! Click here to know Auto Text Click here to get free trial
Select a cell and use this formula =ODD(RANDBETWEEN(X,Y)) (X and Y indicates any integer numbers, and X<Y), for instance, here I will generate random odd numbers in a range of -12 and 12, now I type =ODD(RANDBETWEEN(-12, 12)) into a cell, then press Enter key. If you need, you can drag the fill handle to fill a range with this formula.
If you are insterested in inserting random integers, dates, times, text strings and custom list, you can free install Kutools for Excel and apply its Insert Random Data utility to achieve the tasks.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
After free installing Kutools for Excel, please do as below:
Select a range and click Kutools > Insert > Insert Random Data.
Count times a word appears
|If you want to count the times a specific word appears in a single cell or a range, you can try Count times a word appears of Kutools for Excel, it may make a big favor for you.|