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


--
judoist
------------------------------------------------------------------------
judoist's Profile: http://www.excelforum.com/member.php...o&userid=10595
View this thread: http://www.excelforum.com/showthread...hreadid=486864

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