Thread: Identifying the every nth document in a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
  
Posts: 510
Default 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
Reply With QuoteReply With Quote