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
 
Ad

Advertisements

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

Advertisements

D

dlw

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top