| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering times in Excel 2007
Hi,
I have a list of times, automatic data was taken every 15 seconds (I have over 5,000 rows of data). I need to show only times that end in 00, so a whole minute. Column A row 1 Time row 2 00:00:00 row 3 00:00:15 row 4 00:00:30 row 5 00:00:45 row 6 00:01:00 In this example only rows 2 and 6 would be returned. Any suggestions. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pls confirm 2007 chart redraw is up to 10 times slower than 2003 | Charts and Charting in Excel | |||
| Excel 2007 - Filtering and copying | Excel Discussion (Misc queries) | |||
| Double Filtering in Excel 2007 | New Users to Excel | |||
| Another Filtering Question for Excel 2007 Experts | New Users to Excel | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Threaded Mode
