Results 1 to 1 of 1

problematic problem

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2005
    Posts
    58

    problematic problem

    hi guys, this is my problem:

    in column A: vehicle no ( there are 10 vehicles)
    column B: start km
    column c : end km
    clm D: km travelled
    in clumn e: date
    in clm f : tyre replacement: 1,2,3,4,5 (can choose and number is the location of the tyres)

    now i wan to use a formula to return the cumulative distance travelled by a vehicle when tyre of the same location is changed.(e.g location 1).

    i wan to know how long a tyre ( for a certain location ) can last after travelling for how many kilometres. (and it have to be the same vehicle no!)

    the scenario:
    vehicle no start km end km tyre replacement(if any)

    x1234 45 67 1
    z4567 37 65
    x1234 67 85
    z4567 65 100 3
    x1234 85 112 1


    result :112-67=

    The key to this problem is that if one month later, x1234 has tyre change at 1 and the end km is recorded at 250( e.g) The result wil be 250-112
    Last edited by cjjoo; 10-10-2005 at 01:25 AM.

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