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

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?

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

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?

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

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 he
http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd