Select specific numbers from a list based on position

J

judoist

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
 
J

JE McGimpsey

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