Vlookup longest three times

**Dave69rock** · 09-05-2008, 10:43 PM

Hi

In Column A i have Elapsed times that change all the time

starting at A7
00:05:12
00:20:15
01:15:45
00:45:10

column B has customer names

what i want is to display in A1, A2 & A3 is the three longest elapsed times and in column B display the name.

Hope you can help

Dave

**Paul** · 09-05-2008, 10:55 PM

Hi Dave,

In A1 you could use the formula:

=LARGE($A$7:$A$100,ROW())

Then fill that down to A3. You'll need to format the cells appropriately (they will probably default to decimals).

In B1 use:

=VLOOKUP(A1,$A$7:$B$100,2,0)

Hope that helps!