selecting every tenth row in excel

S

steve

Hi,

Does anyone know of a easy way of displaying every tenth
row only in an excel worksheet?

cheers.
Steve.
 
A

Anson

Find a blank column in the table in the first cell, type in the following formula
=if(cell above =10,1,cell above +1)
Copy this formula to the bottom of the table. Then copy and pastespecial>values on the same column to get rid of the formulae. Use a filter to get the 10th row by selecting the 10's in the same column.
 
Top