Results 1 to 3 of 3

Excel 2007 : Identify Same Day Trip Starts

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Identify Same Day Trip Starts

    What I've created is a spreadsheet that represents different schedules for pilots. The number "2" represents the start of a new trip, and the number "1" represents subsiquent day(s) of flying.
    A 1 day trip would look like this:
    2

    A multiple day trip would look like this:
    2
    1
    1
    (etc)

    I'm trying to figure out how many lines have trips that start on the same day consistantly.



    I know only lines 4,7,13,14,21,22,&25 all meet the criteria, but I can't figure out how to get excel to read it and give me a total.

    Any help is greatly appreciated.
    Attached Files Attached Files
    Last edited by Ricker090; 07-01-2010 at 12:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1