Need help adapting a formula to generate a random array of non-repeating numbers

Greetings Excel Users!

I need to create an Excel formula to generate an array of 10 numbers, from 1 to 10, without any duplicates. I found a couple of examples to do something similar, however, I have had trouble adapting these examples to my situation.

Here is a link to the example that I followed: http://answers.microsoft.com/en-us/m...c9daafe?page=1

Please Login or Register  to view this content.

Based on the example above, I am able to generate the random, non-repeating list of numbers from 1 to 10 like I want. However, this formula goes down column A, and I need it to go across row 2 instead. I've been playing around with it for the last 4 hours and I can't figure out how to make it fit my needs.

I've attached an Excel workbook with the formula, as well as an example of how I want to the data to ultimately look.

Thank you

Maybe like this?

Originally Posted by azumi

Maybe like this?

Azumi, thank you very much for taking a look at this. You solution does exactly what I asked for! However, I forget to mention that I ultimately want to take this formula and "drag it down" to essentially create 1000 rows, each row with numbers 1-10, but in a different random order, and no repeating numbers within a single row.

I tried to adapt your formula to allow me to copy it down, but I was once again not able to make it work.

Originally Posted by azumi

Maybe like this?

Azumi, thank you very much for taking a look at this. You solution does exactly what I asked for! However, I forget to mention that I ultimately want to take this formula and "drag it down" to essentially create 1000 rows, each row with numbers 1-10, but in a different random order, and no repeating numbers within a single row.

I tried to adapt your formula to allow me to copy it down, but I was once again not able to make it work.