A
ATW2500
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
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