Anyone know how to do this? Or even if it’s possible?
I’ve got a few worksheets that are larger than I need for some mailing. I need to Nth select it down to 150. Any help would be appreciated.
You mean, select every n-th record?
The way I’ve done that is to add another column and type “1” in the first cell of the column. Then type in the following formula to the second cell, assuming that your new column is column A:
=if(a1=N,1,a1+1)
where N is the number you’re looking for. Then paste that formula all the way down the column. Copy the column and paste-special, “Values” over top of itself. Now sort the whole spreadsheet by that column, and you’ll have all the “nth” records stacked on top of each other.
That works.
Variants include:
use row() rather than A1+1
use =IF(MOD(ROW(),7)=0,1,0) to ID the Nth rows
use filters, there is no need to copy & paste-special then sort
If you have Excel 2007 or above;
set up conditional formating to highlight whichever Nth rows you want
=MOD(ROW(),N)=0
Then use filter by color
Or you could do a =COUNTIF(a1:a…,“N”) on the column I added, or to go VBA and do a Rows.Offset(N,0), or… 