Thanks, it worked very well.
--
NR


"Bernie Deitrick" wrote:

NR,

You could use two columns of formulas. Let's say that you have two blank columns, B and C. In cell
B2, enter the formula

=RAND()

and copy this formula down to match your entire data set.

Then in cell C2, enter the formula

=IF(B2=MAX(OFFSET($B$1,INT((ROW()-ROW($A$2))/70)*70+1,0,70,1)),"Select me","")

and copy that down.

Then apply a filter, and show just the "Select me" values in column C.

If you need to do something with the selection, apply the filter, select the column(s) with the data
that you need, use Edit / Goto.. / Special... "Visible Cells only" "OK" and then copy and paste the
selection somewhere else.

HTH,
Bernie
MS Excel MVP


"Noelline" wrote in message
...
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.

Thanks
--
NR