Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select player from list and get his position in next column | Excel Discussion (Misc queries) | |||
Create a new list that singles out duplicate numbers | Excel Discussion (Misc queries) | |||
Choose data from a particular column based on a specific value | Excel Worksheet Functions | |||
How select an item in a list box | Excel Worksheet Functions | |||
How to filter and list data based on different data. | Excel Worksheet Functions |