Thread: Filtering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SamGB
 
Posts: n/a
Default Filtering


Currently i have a .CSV file which contains all the data that has been
taken directly from another program, i need to filter out all the rows
i need using a filter that will only pick out the rows which contain a
departure time of 10:00 or earlier and insert it into a saved Excel
Spreadsheet which contains all the formulas i need.
Whats the best way of going about this??
Just to give you some background on the project...The data gets
imported from another program called RM Airline Managment

The .CSV file contains data in the following way:

Date | Aircraft reg | Schedualed Dep. time | Actual Dep. time | Delay
time

and i want to filter out the rows which only contain an schedualed dep.
time of 10:00 or less

Any help or ideas greatly appriciated


--
SamGB
------------------------------------------------------------------------
SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263
View this thread: http://www.excelforum.com/showthread...hreadid=510242