Generate random numbers with no repeats?

[limpfisch]

Hi

I want to generate a column of random numbers between 1 and 312
I then want to create a column next to that one also generating a random number between 1 and 312 but cannot use the number in the previous cell.
I want to do this for multiple columns with no repeat on any single row.
How can this be achieved?
Thanks

[MarvinP]

Hi,
Make column A numbers 1 to 132. Make column B =Rand(). Sort by column B.

[limpfisch]

Hi, thanks for your response

However, I don't see how your solution achieves my goal?
Unless I am missing something....

[benishiryo]

hi there. try this array formula in cell B2:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

a similar eg is explained in the file of my link below*Tips & Tutorials I Compiled, sheet 57. it is in ROWS instead while yours is in columns. it also returns a bunch of text available in a column while yours is purely numbers from 1 to 312.

[tim201110]

Can numbers be the same in a column?

[limpfisch]

Can numbers be the same in a column?

they sure can!

[MarvinP]

Hi limpfisch,

You didn't like my answer last night so here is the workbook showing what I meant.

Random Numbers No Repeats.xlsx

You start by creating the numbers in Column A then you sort them randomly, using Column B. If you need a better answer, you should supply a sample workbook.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.