
Thank you in advance for the help:
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