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,
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.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.