You are here: HomeExcelTutorials

# Random Names and Numbers (non-repeating)

## Random Names and Numbers (non-repeating)

Price: FREE

Is there a simple way to take a list of 12 names and randomly assign a number between 1 and 12 (however the numbers cannot repeat).

Visit publisher's web-site: Random Names and Numbers (non-repeating)

Category and Tags: ExcelTutorials :

## Related Tutorials

### Non repeating random numbers

Free: Yes
Tags: Excel ›

I'm looking to fill a range (say a1:a7) via VBA with random whole numbers from 1 to 7 without any repeating values, i.e., each number is only used once in the range.

### generate unique random numbers

Free: Yes
Tags: Excel ›

I have a list of 600 names. I would like to generate a random number between 1 and 600 for each person but not have any repeating numbers. So far I have used =rand()*600 This give me the correct number range but many of the numbers repeat.
Can I accomplish what I want to do?

### 17 random numbers between 1 to 65

Free: Yes
Tags: Excel › Functions

I have a list of 65 names sorted alphabetically. I want to choose 17 names by random. So my tasks is: how to choose 17 random numbers between 1 and 65. I know how to produce random numbers in Excel, but
I don't know how to locate them to be between 1 and 65 .
Raoul Khorana Czar
Kobe University, Kobe, Japan

### generating random numbers without repeats

Free: Yes
Tags: Excel ›

In a1:a20 I have numbers 1-20. I need to put these numbers randomly in
columns B to M without any numbers repeating across the rows. Is this

### Special Random Numbers' Distribution

Free: Yes
Tags: Excel ›

How to insert random numbers between 1-50 in cells A1:A10, with a condition
of using a number once only, i.e. no number repeating.
Thane &

## Related Applications & Scripts

### Random Striped CSS3 Backgrounds

Free: No
Tags: CSS › Excel Background Effects CSS3

A collection of CSS3 Backgrounds made with multiple layers of strips repeating at different intervals based on prime numbers. This causes the overall pattern to appear non-repeating giving it a random feel.

### Flip Numbers

Free: No
Tags: Flash › Excel Random Text

This display allows you to show any number with style. It is easily and fully customizable:
change dimensions.
choose how many numbers visualize.
change the background color of the numbers.
change the numbers color.
change the distance between numbers.

Free: Yes
Tags: JavaScript › Excel Random Images

This is a good script to use for placing random ads on a page. Once the page is loaded, a random image will be selected and placed on the page. If the image is clicked, the visitor will be brought to the website that corresponds to the image.

### AUTO BIRD v1 :: random behavior

Free: No
Tags: Flash › Excel Animations

This drag-n-drop movie clip is a self-contained bird that sits on a wire, fence, branch, etc. and does its own thing. It fluffs its wings occasionally and then at some point it flies off into the sky. After a random wait, it flies back to its original position. You can add as many feathered friends as you want and they will all behave independently. Use some scaling/skewing/tinting to make each one slightly different.
By simply changing a few numbers, their behavior can be modified to have more or less chance of doing any of the actions. The flight path uses a Motion Guide layer.

### Key Generator

Free: No
Tags: ASP.NET › Excel Random Text

The KeyGenerator is a .NET component for .NET applications that allows to developers generate random values using the combination of numbers, letters, characters and custom values.
Principal features:
- Get random values using Numbers, Letters, Numbers & Letters, Numbers-Letters-Characters or custom values defined by you
- Include source code so you can add custom elements
- It is compatible with C# and VB projects (include demo apps for both)
- It is compatible with different types of .NET projects (web, desktop, console)