Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 2Plan

  1. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    This is excellent! Thanks!
  2. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    Trying to be more clear: I need to query the above data set, while excluding certain sequences that were badlisted on a specific date. In other words if the sequence number was badlisted on 9/13/10 then that sequence number would appear in the data set up until 9/13/10, but not after that...
  3. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    How do import the 'ts' (timestamp field above) as a date. Currently, I have to import 'ts' as a text field, but I want to import as a date field. Thanks, for any assistance
  4. 2Plan

    create vlookup to exclude list of numbers from certain date forward

    How can I create a vLookup table to exclude a list of numbers (i.e., the seq column in data set) from a certain date forward from the data set below (data set will be from Sep thru Nov)? I will import the data set below into an access DB first. ts,loc_n,bus,route,ttp,grp,des,seq,tpbc...
  5. 2Plan

    split or extract numeric characters from column

    The formula is even better! Thanks!
  6. 2Plan

    split or extract numeric characters from column

    figured it out. text to column (delimter "-") Thanks.
  7. 2Plan

    split or extract numeric characters from column

    Is there a way I can get just the numbers of this column in a separate column by itself, so I can sort the data? 1-NORTH LAMAR/SOUTH CONGRESS 10-SOUTH 1ST/RED RIVER 17-CESAR CHAVEZ 2-ROSEWOOD 20-MANOR RD/RIVERSIDE 201-SOUTHPARK MEADOWS 21-EXPOSITION 22-CHICON 3-BURNET/MANCHACA 30-BARTON CREEK...
  8. 2Plan

    Count a field and Count Unique occurrence of field

    Just curious, how many rows can we export to excel 2007?
  9. 2Plan

    Count a field and Count Unique occurrence of field

    You guys are great! Thanks for all the info!
  10. 2Plan

    Count a field and Count Unique occurrence of field

    Thanks Randy, Were upgrading to Excel 2007 next month!
  11. 2Plan

    Count a field and Count Unique occurrence of field

    Correct MajP. I just did a test. So if I import the dataset into an access table what simple query would give total seq count and total unique seq count at the same time?
  12. 2Plan

    Count a field and Count Unique occurrence of field

    Randy, Can I move a 200,000 line dataset into an Access table? Thanks. 2plan
  13. 2Plan

    Count a field and Count Unique occurrence of field

    Sorry for the confusion: I've listed the column headers. I need total count of seq column. According to the dataset below, Output "results.txt" file should read: Total Seq Count = 19 Total Unique Seq = 5 ts,loc_n,bus,route,ttp,grp,des,seq,tpbc '2010-07-28...
  14. 2Plan

    Count a field and Count Unique occurrence of field

    I would the output/results to go to a *.txt file. For example the output/results file would read: Total Riders = 192,000 Unique Riders = 3,100
  15. 2Plan

    Count a field and Count Unique occurrence of field

    How can I count the next to last column of the dataset below and count the unique occurrence of the next to last column of the dataset below? Typical dataset is about 200,000 lines; so I would have to use a command to open the ascii file and then count. '2010-07-28...
See more

Part and Inventory Search

Back
Top