Random Generating Number list - no duplicates in columns or rows

[SAB1987]

I am looking for assistance in a formula to generate a random list of numbers between 1 and 15 within two adjacent columns. I am looking for lists without duplicates within each column and within each row.

[MarvinP]

Hi SAB and welcome to the forum,

See if the attached does what you want. You need to press F9 to recalculate until the sum of matches is zero. See the attached.
Rand 15 numbers in Col and Row.xlsx

[SAB1987]

Thank you! This is perfect and I'll be able to adapt the concept. I appreciate it

[Rick Rothstein]

Since you are using XL365, you do not have to fill in all those cells with individual formulas... you need only 3 formulas total. Try the following on an empty sheet...

Put this formula in cell A1:
=RANDARRAY(15,2,1,15,0)

Put this formula in cell C1 and copy it across to cell D1:
=RANK(A1:A15,A1:A15)

[HansDouwe]

a small typo in post #4: correct is: ..... and copy it accross to cell D1
[Thx typo in post #4 is intermediately corrected]