How can i randomly select 780 rows from 4000 rows of data

's Computer Specifications

In Excel i have a spreadsheet with 4000 rows of data and would like to
randomly select a list of 780 rows showing only one cell of the data?

's Computer Specifications

bbb,

Randomly selecting 780 of 4000 rows is simple enough but can you explain
what you mean by ".....showing only one cell of data?"

Mike

"bbb" wrote:

> In Excel i have a spreadsheet with 4000 rows of data and would like to
> randomly select a list of 780 rows showing only one cell of the data?

's Computer Specifications

Hello,

If your 4000 rows are in Sheet1 (rows 1 to 4000) then switch to Sheet2
and:
1. Select A1:A780
2. Array-enter
=INDEX(Sheet1!A1:A4000,UniqRandInt(4000))
(enter with CTRL + SHIFT + ENTER, not only ENTER)

My macro UniqRandInt you can get here:
http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to randomly select rows in Excel?	=?Utf-8?B?U2FtYW50aGE=?=	Microsoft Excel Misc	4	12th May 2005 02:59 PM
How do I select multiple rows randomly in MS Excel?	=?Utf-8?B?VmFydW4=?=	Microsoft Excel Misc	2	18th Apr 2005 08:10 AM
select block of rows w/data between blank rows	=?Utf-8?B?SmFubmE=?=	Microsoft Excel Programming	6	13th Feb 2005 02:45 AM
Select a number of rows randomly in a table ?	Phan Tien	Microsoft VB .NET	1	24th Mar 2004 05:19 PM
Select a number of rows randomly in a table ?	Phan Tien	Microsoft Access ADP SQL Server	0	24th Mar 2004 12:17 PM