LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Filter will not work -- Number Ends With

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Auto Filter "Ends With" Retail Services Excel Discussion (Misc queries) 6 July 20th 07 06:56 PM
filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 Debbie Excel Worksheet Functions 1 April 6th 07 12:07 AM
Filter does not work cj21 Excel Discussion (Misc queries) 3 March 30th 06 02:48 PM
Why does this filter not work properly cj21 Excel Discussion (Misc queries) 6 March 29th 06 09:26 PM
Auto Fill Series when number ends in -1 JGus Excel Discussion (Misc queries) 7 December 23rd 05 03:14 AM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"