#1   Report Post  
Posted to microsoft.public.excel.misc
CalsLib
 
Posts: n/a
Default Data Analysis

I need to generate 12 random (even) numbers from a give set of numbers 1--24.
How do I get excel to do this?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Data Analysis

=RANDBETWEEN(1,12)*2

Copy down so you have 12 rows

--
Kind regards,

Niek Otten

"CalsLib" wrote in message ...
I need to generate 12 random (even) numbers from a give set of numbers 1--24.
How do I get excel to do this?

Thanks



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
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
How do i get the Data Analysis toolpack to work? JamesQMUL Excel Discussion (Misc queries) 2 October 30th 05 04:16 PM
data analysis option not visible Alok Excel Worksheet Functions 2 September 22nd 05 07:50 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM


All times are GMT +1. The time now is 05:41 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"