Vance wrote:
Unfortunately my data sets will not always be 3600 data points. What I am
doing is recording subjects completing a specific task, there time to
completion is going to vary from subject to subject, and therefore I will
have a different number of data points for each subject. I want to normalize
each subjects data to the same number of points so that I can graph them for
easy comparison. Because of the varying number of data points I don't think
your method of deleting a pre-determined ratio of the data points would be
effective.

"Sean Timmons" wrote:

So, you are looking to remove, say, 2 of every three data points...

Try this...

assuming your data is in cells A2 - A3600

=IF(MOD(ROW(A2),3)=0,"","X")

Then, filter your data, use the drop-down to select your X fields, then
delete those rows. this will leave @ 1000 records acrosss your spectrum.

"Vance" wrote:

I have a data set of roughly 3600 data points and would like to convert it to
1000 data points while still maintaining the shape of the curve. I am
currently using excel 2007, but I need the file to be compatible with the
older versions of excel as well.

You could try this modification of Sean's technique. This adjusts the
ratio using the actual number of observations in column A:

=IF(INT(MOD(ROW(A2),COUNT(A:A)/1000))=0,"","X")