Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When using Excel I have a data set that contains three large columns of cells
that contain only numbers ..The first column is a time stamp that increments by 1 (50001,50002,50003, etc.) -- I want to return only the data that correspond to every fifth time stamp. I set up an auto filter that filters based on the first column (Time Stamps) using a custom filter that filters the cells based on "ends with - 4" or "ends with - 9" but the filter returns nothing Interesting ...If I put a letter in front of the time stamp (ie a50001, a50002, etc.) it will filter those data that contain a letter using the filter described above Any Ideas???????? Here is a slice of my spreadsheet: Time Stamp Northing Easting 150155 804916.851 388281.598 150156 804916.852 388281.598 150157 804916.852 388281.597 150158 804916.847 388281.6 150159 804916.851 388281.594 150160 804916.848 388281.602 150161 804916.849 388281.599 150162 804916.852 388281.595 150163 804916.852 388281.596 150164 804916.85 388281.597 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Auto Filter "Ends With" | Excel Discussion (Misc queries) | |||
filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
Filter does not work | Excel Discussion (Misc queries) | |||
Why does this filter not work properly | Excel Discussion (Misc queries) | |||
Auto Fill Series when number ends in -1 | Excel Discussion (Misc queries) |