Excel Filtering

  Phate 17:28 20 Apr 2010

Hi all - got a bit of a problem i'm hoping someone can help me with.

I currently have a very large data table with the first column having numbers increasing sequentially from 1 - 190k (1,2,3,4,5 etc)

I am trying to filter this table to show me every 60th record (eg 0,60,120,180,240 etc)

I've tried fitering the table using the existing options in excel 2007 but haven't really found a way to do this, and was just wondering if anyone had any ideas?


  VoG II 17:33 20 Apr 2010

In a spare column enter in row 1


and copy the formula down to the end.

Then filter on that column = 0.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?