use of Randbetween() in Excel

[dimitris]

Hi to everyone.

I had 10 columns in Excel.

A1 B1 C1 ……J1
..... … … ………
… … … ………
A50 B50 C50 j50



Each column uses the Randbetween() function to create integers 1-100, that
is Randbetween(1,100).
Is there anyway to use somehow the function so the integers in every row to
be different?

(I mean: A1 <> B1<> C1…….<>J1, A2 <> B2 <> C2…..<> J2,……………,
A50 <> B50 <> C50 …….<> j50)
Thank you.

 

[Niek Otten]

http://www.mcgimpsey.com/excel/udfs/randint.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi to everyone.
|
| I had 10 columns in Excel.
|
| A1 B1 C1 ..J1
| .... . . ...
| . . . ...
| A50 B50 C50 j50
|
|
|
| Each column uses the Randbetween() function to create integers 1-100, that
| is Randbetween(1,100).
| Is there anyway to use somehow the function so the integers in every row to
| be different?
|
| (I mean: A1 <> B1<> C1...<>J1, A2 <> B2 <> C2...<> J2,.....,
| A50 <> B50 <> C50 ...<> j50)
| Thank you.
|
|