View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Select specific numbers from a list based on position

Not sure what you mean by "select and display", but assuming all your
numbers are in one column (say, column A), you could enter this in row 1
of another column:

=INDEX(A:A,ROW()*20)

and copy down as far as necessary.


In article ,
judoist wrote:

I have a column of 1000 numbers. Is it possible to have Excel select and
display each 20th number. ie the 20th, 40th, 60th number, etc