![]() |
#1
|
|||
|
|||
![]() ![]() Here is the scene, a spread sheet, contains 5 columns, many rows as follows: Col 1 - Date Col - 2- Clock time i.e....02:25:45 Col -3 - GPM Col - 4 - W/L Col - 5 Data What I need to do: I would like to be able to filter the data by the time row, where I can eliminate all rows that do not equal my criteria. I used to have a formula that was given to me years ago (which I have lost) that went something like this: select all the data >data>filter>text filter>does not equal......... this is where I lost it. I need to be able to filter the "time" column by a selected minute , say I only want to filter the data by 5 minutes, or 10 minutes. Thanks again everyone for the help |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
roderh | Excel Programming | 2 | 09-06-2015 08:54 PM |
Automatically Delete Slides based on current time | Pacman52 | PowerPoint | 2 | 07-16-2015 05:30 AM |
![]() |
dharani suresh | Excel Programming | 5 | 04-29-2014 03:25 AM |
Looking for an add-in or a way to send automatic replies based off a list | brady | Outlook | 0 | 04-19-2013 01:21 PM |
![]() |
akraw | Word | 3 | 03-26-2011 08:29 PM |