Ends with, begins with, contains, does not contain, does not begin with etc.
only work with text



--


Regards,


Peo Sjoblom



"ATW2500" wrote in message
...
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