Identifying the every nth document in a column
 

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

Identifying the every nth document in a column
 

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.............................


"boby" wrote in message
...
how to identify the every 50th document in the column, work sheet contains
60,000 columns

Identifying the every nth document in a column
 

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

"boby" wrote:

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