Find function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alamo - 16 Sep 2005 11:52 GMT

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

Signature

alamo

Reply to this Message

Domenic - 16 Sep 2005 14:01 GMT

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!

> How can i get the last values on next table :
>
[quoted text clipped - 20 lines]
> THE LAST VALVULINE CHANGE
> THE LAST TIRE CHANGE

Reply to this Message