Select specific numbers from a list based on position

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

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.1yuthy_1132588801.9102@excelforum-nospam.com>,
judoist <judoist.1yuthy_1132588801.9102@excelforum-nospam.com> 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