Close Window

How To Generate Non-repeating Random Numbers

Is there a way to use the randbetween function (to generate numbers between 1 and 100)and generate a column that is 100 rows deep, but with numbers that are never the same?

Thank you.

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

How to generate random whole numbers (integers) that are between two numbers.  This allows you to set a minimum and ...

Excel prank where a random cell is selected each time a user tries to select a cell. For instance, if you select ce ...

How to stop formulas and functions from updating in Excel when running a macro. This can save you a lot of time if ...

How to add, manage, and remove trendlines in Excel Trendlines allow you to show trends in charts that might be oth ...

Helpful Excel Macros

- Generate a series of non-repeating random numbers in Excel with this UDF (user defined function). This is a great funct

- This free Excel UDF allows you to get the numbers out of a cell that contain both text and numbers. This is a great fun

- Return the highest number between two numbers that is in a range of cells with this UDF (user defined function) in Excel

- This macro will delete all text from selected cells. This will not delete any other characters or numbers from any cell

- This Excel Macro works like a better Vlookup function because it returns ALL of the matching results. Run the

Similar Topics

I want to create 6 numbers from 11 numbers..
lets suppose my numbers a 1,2,3,4,5,6,7,8,9,10,11
I want to generate all possibilities of the 6 numbers. But i dont want duplicate series.. I mean 1,2,3,4,5,6 and 6,5,4,3,2,1 are duplicates.


Is there a worksheet function that will generate all possible combinations of
a set of given numjbers. For example, 1, 3 and 8 would generate 138, 183,
318, 381, 813, 831 and so on...

I want to generate all possible combinations of 11 combination 4. I know there are 330 possible combinations but how can i let excel generate all the combinations. 1-11 combination 4.

For example. 1 2 3 4 5 6 7 8 9 10 11 taking 4 at a time:

Right now I have a sports league with 8 teams, I'd like to create a random 7-game schedule where each team plays the other team only once. Essentially this will be a 7-game round robin. However, I'd like to be able to use this for any number of teams and games.

I'd like to do this in Excel, but I can't figure out how to have a randomly generating non-repeating macro with text values in cells.

So right now I have a column of 8 values and need matrix of 7 columns by 8 rows next to it.

I've found this thread that has one for numbers, but I can't figure out how to do it for text values...

/ />
Thanks all!

I'm sure this has been addressed before, and I'm sure one of you 50lb heads has the answer I'm looking for. I want to generate a bank of 200-300 questions in excel and be able to make a test of 50 questions that will be different every time. I want to be able to do this with multiple choice questions as well as just plain essay questions. Can I have some instruction or examples? Thanks guys!

Hello gurus!

Here's my question...I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount.
List of Numbers

Amount to be reached = 12

These are some of the possible combinations to reach 12 :

Is there a function in Excel that will do this for me? I want to know which numbers (i.e. cells) can be added to reach 12. AND, if possible, colorcode the cells added for each combination.

Good luck and thanks!!

I need help writing a formula to add a column of numbers until a value is reached, then start over adding numbers starting at the next cell after the value is reached.

Thanks for any help.


Hi there, I have a string of numbers and I would like to add zeros to the end of it.

For example my numbers are formatted like this: 1234 and I would like to add zeros to the end so it looks like this: 123400 (no decimal).

I would do it manually but I have a column of over 2000 different numbers.

Thanks for your help, you guys are great!

I need a set of formulas to list all 120 permutations of the letters ABCDE, can anyone help?!

dear supervirsor
i would like to know how to change english numbers to arabic number on excel
, where when i change the language from english to arabic the numbers didnt
changed it still in english

Hi folks,

Hoping someone can help me quickly as I'm pulling my hair out and have a deadline getting too close.

Been trailing the net and this board but can't work out how to do a simple variance.

How do I work out the difference between two numbers - including negatives.

If the numbers are all positive, it's fine as it's simply a case of A - B = C which is your difference. However, that doesn't work if B is negative.

I need a formula that would give the following:

First Number / Second Number / Difference
1 / 5 / 4
1 / -5 / -6
-1 / 5 / 6
-1 / -5 / -4
-5 / -1 / 4

Hopefully there's a simple function I've been missing.

Thanks in advance, R

Hi Everybody,

First post on the forum, have only recently joined and im hoping that someone can help me before my head explodes!

I am trying to prepare a simple Material Quantity List for some Steel materials.
The materials are all in specific sizes.

What i want to do is, as i input the length, width and height of the structure in the spreadsheet, the Material Quantity List will generate the quantity of each piece of material i will need.

Does anybody know of a formula for this. I have been trying to use the IF function and getting absolutely nowhere, all suggestions will be highly appreciated!!


I need to know the formula (if there is one) for Excel to figure all the possible combinations of a given set of numbers that will add up to a specified sum.

In other words, if I give the following numbers 1, 2, 2, 3, 3, 4, 5, 5, 6, 7, 7 - I want Excel to figure all the possible combinations that will add up to 23, and also SHOW ME those combinations, and not just HOW MANY combinations there are.

i.e. one possible combination is 2, 2, 3, 4, 5, 7

Can this be done? What is the formula? I'm having a hard time figuring it out!!


Hi Forum,

Need help to generate Series of Items in different Permuation & Combinations..

For Ex:- If there are three Items.. A B C and forming a group of 2
then the the total no of combinations would be permut(3,1) = 6...

I need this to be shown as follows depending on the no of itmes and no of group no=2 in this case...

Permuations & Combinations are as follows:


i've been trying to figure this out on my own but seem to be hitting road blocks.

i have a column of numbers that we extracted from a database as whole numbers. for instance, 30 should be .30 and 100 should be 1.00. when i try to increase or decrease the decimal point it doesn't allow me to convert it to those positions.

would any one have a tip of how i can easily convert this? there are over 2000 entries in my excel spreadsheet so to do it manually would take a lot of time/effort.

thank you!

Dear All,
I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout..
Please provide me with any Formulas as micros are disable in my Computer.....

Waiting for an early reply.......


I am trying to understand why I can not use Ctrl+F to find data in Column B, yet I can find the data in Column A.

I have a worksheet that in column A has numbers, in column B, the following formula "IF(ISNUMBER($A1),$A1,"").

Ctrl+F will find numbers in Column A, yet not in Column B. Why is this so? What can be done to ensure Ctrl+F works in Column B?

First time in this forum. Hi all. I have a challenging question, is there a way either by VBA or manually (preferably both, if possible) to actually unite the X amount of numbers that are in a cell given the contents is alphanumeric? I'll give you the following examples to see if you can understand what I' referring to?

DATA output should be
asd67,h876 --------> 67876
2,3,ujdj5&34 -------> 23534
909k86m34 --------> 9098634

Hope this makes sense?

After you filter out data, how to you re-number the row numbers so they are, again, consecutive?


I'm a bit of a newbie with Excel, but...

I have several cells with data that contain both letters and numbers (4H, 8V, 4FH, etc.) What I want to do is remove only the text characters from these cells, and add the remaining number values together among a series of cells with this data type.

If your answer involves using a macro or VB, please provide a link on how to use the formula. I've never used a macro or VB.


I know this question has been asked a bajillion times, so I apologize for the redundancy.

I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a .csv. So if I do that, close the Excel window, and then open again (as the .csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as .csv, close the window and then open that file up again, that dang scientific format is back.

Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to "stick" so that they don't revert back to scientific format when I reopen the file?

Thanks so much for your help!

I have a list of 10-digit numbers, but I want to apply a formula/function or
format the cells so that only the first 6 digits show up. Is this possible?

I have a problem: I can't show some rows after they've been hidden with a macro. I tryed the "select all / unhide", but it doesn't work.

I noticed the row numbers are all blue now. What does it mean? (This could be the answer..:P)

Hello everyone, I am new to this forum and have been using excel for about 3 years. I have learned alot but still can not figure out how to make numbers add up in one box like a running total. Meaning, If I have a list and in the list is one cell for each item say like cell a1 is for a can of coke and cell a2 is for a car tire and so on,and i want to keep a running total by adding a number to cell a1 or a2 like say "3 i.e. 3 tires or cans of coke" and later that day i come back and need to add 2 more i want to be able to just click on the cell a1 or a2 and enter the number 2 and the cell would add the number in it to the number im adding to it to show a result of 5 tires or whatever. I am sorry If i am not asking the question in an understandable manor but its the best way I can think to ask anyways, any help would be appreciated, Thanks in advance.


I am trying to work out how to calculate the geometric mean of a series of values, some of which are negative, ie. investment returns over a series of years with some negatives.

The Geomean function doesn't work because it only uses positive numbers.

Any help would be greatly appreciated.

Related pages

trend calculation in excelwinning percentage calculator win loss tiehow to create a rotaexcel macro find last rowvacation sick time tracking templatecalculate eigenvalues in excelmm to fraction inchhistogram excel bin rangevlookup example to compare two columnsunique records only excelunprotect excel 2007 workbookexcel hidden worksheetexcel formula unique countexcel overtime templateexcel vba remove rowconsolidate data from multiple worksheets in a single worksheetultravnc mouse not workingexcel macro remove blank rowsaccidentally deleted excel filecanadian payroll calculator freehow to sort data in excel 2007combine two lists in excelhow to copy a formula down a column in excelconvert csv to dat fileexcel macro find last rowexcel vba copy and pastehow to do an hlookupexcel vba filter rangemean median mode and standard deviation calculatorteradata 3706convert kg to stone and lbsrandbetween excelvba unprotectvba not equal signhow to get rid of filter keyslock column excelsubscript in word shortcutvlookup duplicate valuesworksheetfunction.sumexcel invoice template with automatic invoice numberinghighlight duplicate excelpayback method formulacompare two lists in excel and find differenceswww nseindiamessagebox custom buttonsfill handle excel 2007variance formula in excelsetting up amortization schedule excelcalculate fv in exceltournament random draw generatorvba code to send emailscatter chart excel multiple seriestide height calculatorblock row excelsoftball schedule generatorhow to unhide columns on excelvba activesheet nametimeline generator excelvbe6.dllhour in decimalsmst time to philippine timeclose file vbahow to fix the cell in excelword vba checkboxhow to calculate vat in excelexcel macro rcexcel formula bracketsmortgage function excelcalculate true airspeedobject doesn t support property or method datepickerrefresh pivot table in vbaexcel 2010 autofit row heightweight conversion from stone to kgexcel character codeseconometrics excelirr formula excelexcel modulodbf excelexcel polynomial functionexcel pop up calendarhow to unconcatenate in exceleigenvector excel