Random numbering

[hopelessvolunteer]

Hello all, new to the board.

I have a list of names in Column A going from row 2 to 15. I want to randomly assign them a number ranging from 1-14, but that random number can not be assigned twice. I only need each number once.

I am putting the formula in column B.

Can someone please help me.

Thanks!!

 

[hopelessvolunteer]

randoom

Bump, can anyone help on this?

Thanks in advance.

 

[btadams]

A simple way to check if your random header is the same as the heeler is to enter this formula in column E and fill down:

=If(A2=C2,"Same Header/Heeler!","")

Then press the F9 key until you see no warning messages. Copy the results into a new worksheet using Paste Special -> Values

 

[hopelessvolunteer]

Random

Thank you so much for that formula, it works great!

Each time I switch worksheet it re-does the draw, how do I get it to quit doing that?

 

[btadams]

A simple way would be to put this formula in column E and fill down

=If(A2=B2,"Warning, same Header/Heeler!!!","")

Then press the F9 key until you get no warnings and copy, Paste Special -> Values into a new worksheet

 

[btadams]

sorry for the double post.

It shouldn't be recalculating when you switch worksheets. It should only recalcualte when you change the value of a cell.

Anyway, you can stop the recalculation by going to Tools -> Options and on the Calculation tab select Manual Calculation. Then Excel will only recalculate when you press the F9 key.

But if you leave calculation in manual mode you need to realize that all formulas will only be calculated when you press F9.

 

[hopelessvolunteer]

Random

Thanks, for all of your help!!