Display Every 10th line

[coolrunnings]

I have a plot of data with about 1000 points.

How do i write a function to get excel to display every 10th point in another column

Also, how do i get excel to find the average of every 10th cel and display it in another column

[Domenic]

Assuming that Column A contains your data...

For a list of every 10th cell...

C1: leave blank

C2: =(MOD(ROW(A2)-CELL("row",$A$2)+0,10))=0

1) Select your data, including header

2) Data > Filter > Advanced Filter

3) Check 'Copy to another location'

4) Criteria range: $C$1:$C$2

5) Copy to: $B$1

6) Click OK

To calculate the average of every 10th cell...

=AVERAGE(IF((MOD(ROW($A$2:$A$1001)-CELL("row",$A$2)+0,10))=0,$A$2:$A$1001))

...confirmed with CONTROL+SHIFT+ENTER.

Note that the above formulas return the results for every 10th cell starting with the first cell in the range. If you'd like to have every 10th cell, but start with the 'first occurence' of '10th' instead, change the '+0' bit in the formulas to '+1'.

Hope this helps!

I have a plot of data with about 1000 points.

How do i write a function to get excel to display every 10th point in another column

Also, how do i get excel to find the average of every 10th cel and display it in another column

[coolrunnings]

thanks a lot!
worked like a charm.