Select specific numbers from a list based on position

  • Thread starter Thread starter judoist
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select every 10th number in a list 4
How can I format a cell on a specific date? 7
logical functions utilizing percentiles 7
I need a formula 1
How can I always display numbers produced from subtractionas posit 2
Get numbers from row 11
Numbers showing Up Centered in Cell ? 1
Filter numbers 3

Back
Top