Random Numbers

[Guest]

I need to generate random numbers down from 1 to 18 and then repeat the
random numbers over 18 columns down 18 rows without the same number repeating
itself next to the cell next to it on either side.
Is this possible?

 

[R.VENKATARAMAN]

enering random numbers is easy.

enter

=randbetween(1,18)

and copy this formula over a range of rows and columns
as the random numbr will continously change when you operate any cell in the
sheet
highlight the number and copy and pastespecial-values in the same place

now for unique numberssee the thread in the newsgroup
microsoft.public.excel.programming

the url is

http://groups-beta.google.com/group/microsoft.public.excel.programming/brows
e_frm/thread/e245429428971cc7/234e17d9614293fc?q=unique+random+numbers&rnum=
1#234e17d9614293fc

dont click ,highlight the three lines and paste it in the address bar of
your browser. and click <enter>