Select certain data rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lee's news - 19 Dec 2006 20:14 GMT

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

Reply to this Message

Otto Moehrbach - 19 Dec 2006 21:19 GMT

One way: (VBA solution)
I assumed the time values are in Column A starting with A2. HTH Otto
Sub HideRows60()
Dim TheRng As Range
Dim c As Long
Set TheRng = Range("A2", Range("A" & Rows.Count).End(xlUp))
For c = TheRng.Count To 1 Step -1
If TheRng(c).Value Mod 60 <> 0 Then _
TheRng(c).EntireRow.Hidden = True
Next c
End Sub

>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
[quoted text clipped - 3 lines]
>
> many thanks

Reply to this Message

Rate this thread: