sorting out rows

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have 1000 rows of data and i want to copy or link every 5th row to another
sheet...
thanks...
 
Hi Tom,

Assuming you want rows 5, 10, 15 ... then
1. Suppose the data is in the range J1:J1000 with titles in the first row.
In a blank column, say K, enter the following formula in K2:
=1/MOD(ROW(),5)
and fill it down.
2. Choose Data, Filter, AutoFilter
3. Open the autofilter in K1 and choose #DIV/0!
4. Select the visible cells in column J and copy then to another sheet.
 
Back
Top