Excel Filtering

  Phate 17:28 20 Apr 10
Locked

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?

Thanks,

  VoG II 17:33 20 Apr 10

In a spare column enter in row 1

=MOD(A1,60)

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.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5