excel formula to copy every Nth value

[KB447]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I copy every nth value in a colum to a new colum? (want to reduce a data set for plotting). Foor example, reducing a 1000 points to 250 by copying every 4th point to a new colum.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I copy every nth value in a colum to a new colum? (want to reduce a
data set for plotting). Foor example, reducing a 1000 points to 250 by copying
every 4th point to a new colum.

There are a couple of pretty easy ways. Here's one. Add a new column. Enter
1,2,3,4 and the first 4 cells, and then select all 4 and fill down for the
length of the column. You could then sort on this new column, or filter it
to make a new data set for plotting. Filtering may be a bit easier as hidden
values will not be plotted.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I copy every nth value in a colum to a new colum? (want to reduce a
data set for plotting). Foor example, reducing a 1000 points to 250 by
copying every 4th point to a new colum.

Just another way:

In B1:

=INDEX(A:A,(ROW()-1)*4+1)

Copy B1 down to B250.