+ Reply to Thread
Results 1 to 2 of 2

Find function

  1. #1
    alamo
    Guest

    Find function


    How can i get the last values on next table :

    DATE KM TYPE
    16-06-2001 233.513 TIRE CHANGE
    16-10-2001 281.634 VALVULINE CHANGE
    09-03-2002 356.210 TIRE CHANGE
    06-03-2003 515.783 VALVULINE CHANGE
    29-08-2003 597.360 OIL ENGINE CHANGE
    09-09-2003 602.500 TIRE CHANGE
    28-11-2003 643.266 OIL ENGINE CHANGE
    11-02-2004 681.003 TIRE CHANGE
    04-03-2004 693.005 OIL ENGINE CHANGE
    20-04-2004 717.489 TIRE CHANGE
    26-05-2004 720.890 TIRE CHANGE
    01-07-2004 732.628 OIL ENGINE CHANGE
    24-07-2004 761.683 TIRE CHANGE
    01-09-2004 781.207 OIL ENGINE CHANGE
    01-09-2004 781.207 VALVULINE CHANGE
    29-01-2005 840.225 TIRE CHANGE



    DATE KM
    THE LAST OIL CHANGE
    THE LAST VALVULINE CHANGE
    THE LAST TIRE CHANGE


    --
    alamo

  2. #2
    Domenic
    Guest

    Re: Find function

    Assumptions:

    A1:C17 contains your data

    First row contains your headers/labels

    E2: Oil Engine Change

    E3: Valvuline Change

    E4: Tire Change

    Formula:

    F2, copied down and over to the next column, Column G:

    =LOOKUP(2,1/($C$2:$C$17=$E2),A$2:A$17)

    Hope this helps!

    In article <alamo.1vgbzn@news.excelbanter.com>,
    alamo <alamo.1vgbzn@news.excelbanter.com> wrote:

    > How can i get the last values on next table :
    >
    > DATE KM TYPE
    > 16-06-2001 233.513 TIRE CHANGE
    > 16-10-2001 281.634 VALVULINE CHANGE
    > 09-03-2002 356.210 TIRE CHANGE
    > 06-03-2003 515.783 VALVULINE CHANGE
    > 29-08-2003 597.360 OIL ENGINE CHANGE
    > 09-09-2003 602.500 TIRE CHANGE
    > 28-11-2003 643.266 OIL ENGINE CHANGE
    > 11-02-2004 681.003 TIRE CHANGE
    > 04-03-2004 693.005 OIL ENGINE CHANGE
    > 20-04-2004 717.489 TIRE CHANGE
    > 26-05-2004 720.890 TIRE CHANGE
    > 01-07-2004 732.628 OIL ENGINE CHANGE
    > 24-07-2004 761.683 TIRE CHANGE
    > 01-09-2004 781.207 OIL ENGINE CHANGE
    > 01-09-2004 781.207 VALVULINE CHANGE
    > 29-01-2005 840.225 TIRE CHANGE
    >
    >
    >
    > DATE KM
    > THE LAST OIL CHANGE
    > THE LAST VALVULINE CHANGE
    > THE LAST TIRE CHANGE


+ Reply to Thread

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