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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…