View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
lee's news lee's news is offline
external usenet poster
 
Posts: 1
Default Select certain data rows

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