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 - 18 Jun 2007 08:02 GMT
http://www.mcgimpsey.com/excel/udfs/randint.html

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi to everyone.
|
[quoted text clipped - 13 lines]
| A50 <> B50 <> C50 ...<> j50)
| Thank you.