How do I create a data series of every third (3rd) data point in a long string?
J Joseph Mar 7, 2009 #1 How do I create a data series of every third (3rd) data point in a long string?
J Jon Peltier Mar 8, 2009 #2 Is this what you want? Decimating the Data (Plotting Every Nth Point) http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024 If you just want the sparse array of points, you can skip the line series and use the formulas which put #N/A is all but the Nth cells, or use other formulas which pull the data from every Nth cell into an adjacent column. - Jon
Is this what you want? Decimating the Data (Plotting Every Nth Point) http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024 If you just want the sparse array of points, you can skip the line series and use the formulas which put #N/A is all but the Nth cells, or use other formulas which pull the data from every Nth cell into an adjacent column. - Jon
