Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 mark (plymouth) Posts: n/a
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.
#2
Posted to microsoft.public.excel.worksheet.functions
 Gary''s Student Posts: n/a
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post tim Excel Worksheet Functions 3 April 21st 23 10:07 PM [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM jbf frylock Excel Worksheet Functions 9 January 6th 06 04:50 PM Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 11:11 PM

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