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

[Guest]

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?

 

[Guest]

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

 

[Bernd P]

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