Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
I'd open the csv file (another workbook will open).
then filter to show all the times I don't want ( time(10,0,0)) and then delete those visible rows. Then remove the filter and copy the remaining data to its final home. (and close that .csv workbook, too.) I bet that a recorded macro would get pretty darn close. SamGB wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Either auto or advanced filter, easiest would be autofilter, apply the
filter, from dropdown in the Sched departure time select custom and greater than 10:00, then select the visible table, press F5, special and visible cells only, then delete them. Finally copy the rest of the data to where you want it. Maybe even record a macro while doping this -- Regards, Peo Sjoblom Portland, Oregon "SamGB" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Alternatively you could import the .csv file, save it as workbook,
create a new workbook and define a database query using the saved workbook. You can have your formulas alongside the query and Excel will automatically maintain them as the number of rows increases or decreases. So you wouldn't need your old workbook anymore. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Using Filtering | Excel Discussion (Misc queries) |