Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching numbers in Worksheet? Johncobb45 Excel Worksheet Functions 2 July 31st 06 10:02 AM
Worksheet function for range of numbers brendan_doc Excel Worksheet Functions 1 February 9th 06 06:15 PM
How can I create a fill that increments based on worksheet numbers Amanda097 Excel Worksheet Functions 3 February 7th 06 08:39 PM
how can I check a worksheet for duplicate entries or numbers? RFI Excel Worksheet Functions 1 October 19th 05 04:08 AM
How do I convert numbers into words in excell worksheet? Surendra Excel Worksheet Functions 1 December 31st 04 12:17 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"