selecting every tenth row in excel

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hi,

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

cheers.
Steve.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter away rows of data 2
Data | filter 1
Can excel to pull out every tenth row into a separate sheet? How? 2
dragging formula to make selection 2
Excel time conversion - Please help!! 5
how do I work out age in years, months, days in excel 1
calculating time with tenths 6
How do I grab data from every tenth row of a 5,000 row spreadsheet??? 1

Back
Top