# Identifying the every nth document in a column

B

#### boby

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

K

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

D

#### dlw

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