Excel Filtering

  Phate 17:28 20 Apr 2010
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 2010

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?