So do you need a random selection:


http://www.mcgimpsey.com/excel/udfs/...noreplace.html

or a sample every seventy rows? Or a random selection from each 70 rows.

J1: =INDEX($A:$A,(ROW()-1)*70+1)

copy down as far as necessary...

or one sample from each 70 rows:

J1: =INDEX($A:$A,(ROW()-1)*70 + INT(RAND()*70)+1)
copy down...




In article ,
Noelline wrote:

Hello all, I need your help, I am working with large excel data and I need a
formula so that I can generate a random selection every 70 rows, what kind of
formula do I need and how do I integrate it in my worksheet? All answers are
welcome.