View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Searching numbers in Worksheet

See this:

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

Biff

"Johncobb45" wrote
in message ...

I have one more question.
Is it possible to fill random numbers in a column?
I want excel to enter for me 20 random numbers (between 1 and 80) in to
a column.
Is it possible to do it with one click instead entering them manualy
one by one, for example by clicking or filling just one top cell?
If you need more explanations please let me know.
Regards,
John


--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile:
http://www.excelforum.com/member.php...o&userid=16582
View this thread: http://www.excelforum.com/showthread...hreadid=567296