Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advance filtering with multiple conditons falloutx Excel Discussion (Misc queries) 3 January 21st 06 07:28 PM
filtering magix Excel Discussion (Misc queries) 4 December 11th 05 10:04 AM
Row filtering based on input box entry (column heading) Santed593 Excel Worksheet Functions 4 August 18th 05 12:35 AM
trouble filtering a list. Why isn't column filtering? Pat Excel Worksheet Functions 1 July 18th 05 03:30 PM
Using Filtering KellyB Excel Discussion (Misc queries) 2 December 6th 04 09:27 PM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"