Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark (plymouth)
 
Posts: n/a
Default formula to select numbers from a range

I am trying to create a formula which would select 6 unique numbers from a
range between 1 and 24 and list trhem into a cell.
Can anyone help please?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default formula to select numbers from a range

Do it in two steps:


In A1 thru A24 enter 1 thru 24
In B1 thru B24 enter RAND()

Sort the columns by column B (this will shuffle the data in column A)

In C1 enter
=A1 & A2 & A3 & A4 & A5 & A6
This will pick up a randon, unique set of numbers.

--
Gary''s Student


"mark (plymouth)" wrote:

I am trying to create a formula which would select 6 unique numbers from a
range between 1 and 24 and list trhem into a cell.
Can anyone help please?

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
What formula is used for subtracting a range of different cells f. tim Excel Worksheet Functions 3 April 21st 23 10:07 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM
Range of numbers in a formula...PLEASE HELP!!! jbf frylock Excel Worksheet Functions 9 January 6th 06 04:50 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 11:11 PM


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

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

About Us

"It's about Microsoft Excel"