Identifying the every nth document in a column

[boby]

how to identify the every 50th document in the column, work sheet contains
60,000 columns

 

[Ken Wright]

Do you mean 60,000 rows?

Are we to assume you have a list of documents, one per row, and that you
would like to retun a list of every document in every 50th row?

Assuming that is the case, then in any other column, though preferably one
next to the column of document references, pop a title into say B1 and then
starting in B2, put the following formula and copy down

=IF(MOD(ROW(),50)=1,"FLAG","")

This will flag the data on the 51st row, the 101st row etc (Assuming you
have titles in row 1 and so the 50th doc is on row 51).

If you actually want the docs on row 50 / 100 / 150 etc then just change the
1 to a 0

=IF(MOD(ROW(),50)=0,"FLAG","")

Now just filter on Column B for the word FLAG

Regards
Ken.............................

 

[dlw]

=INDEX($A$1:$A$60000,ROW()*50)
if A is the column with the document, then copy it down