Select certain data rows
Use a helper column, say column B (could be any spare column).
In B2 enter:
=MOD(A2,60) and copy down
You will see in A1 thru B25 something like:
time helper
5 5
10 10
15 15
20 20
25 25
30 30
35 35
40 40
45 45
50 50
55 55
60 0
65 5
70 10
75 15
80 20
85 25
90 30
95 35
100 40
105 45
110 50
115 55
120 0
Then turn on the AutoFilter and select 0 for the helper column.
--
Gary's Student
"lee's news" wrote:
I have 5 columns of data, the first column is time. In this column each row
is incremented in 5mins. So it goes 0,5,10,15,20,25 etc. I want to filter
the data to only show rows every 60 minutes i.e. 0,60,120,180 etc. Have can
i do this, ive had a play with filters but cant seem to find a way. I have
1000's of minutes so it is a pain to manually select each row.
many thanks
|