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/...gramming/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
anuterrnd wrote in message
...
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?