It doesn't make sense to me. What is in the other 9 columns?
Ken


On Feb 20, 3:26*pm, Steve Walford
wrote:
Hope someone can help

Using Excel 2002

I have a large spread sheet, which details the amount of fuel issued
to individual vehicles over a set period (monthly)

The sheet has twelve columns and aprox 4,000 rows, I have only shown
three columns below

Fleet is a unique vehicle reference, in theory that vehicle could fuel
up every day

I need to extract a the complete row for each fleet number that has
the highest amount of fuel against it

ie rows marked *

Fleet * * * * * Driver * * * * *Fuel

01486 * * * * * CLUBLEY J * * * 44.02
01486 * * * * * CLUBLEY J * * * 48.11
01486 * * * * * CLUBLEY J * * * 50.02 * *
01487 * * * * * PINDER G * * * *32.02
01487 * * * * * PINDER G * * * *35.00
01487 * * * * * PINDER G * * * *40.00
01487 * * * * * PINDER G * * * *42.79
01487 * * * * * PINDER G * * * *43.01 * *
01488 * * * * * BREDDY M * * * *23.49
01488 * * * * * BREDDY M * * * *33.56
01488 * * * * * BREDDY M * * * *49.76 * *
01492 * * * * * JBUTTERIL * * * 39.13 * *
01493 * * * * * GREEN A * * * * 0.00
01493 * * * * * GREEN A * * * * 32.29
01493 * * * * * GREEN A * * * * 36.20
01493 * * * * * GREEN A * * * * 37.00
01493 * * * * * GREEN A * * * * 42.39 * *
01495 * * * * * FIRTH C * * * * 29.29
01495 * * * * * SUTTON M * * * *30.37
01495 * * * * * FIRTH C * * * * 37.33
01495 * * * * * FIRTH C * * * * 38.05
01495 * * * * * FIRTH C * * * * 41.63 * *
01496 * * * * * Pardoe W * * * *28.75
01496 * * * * * LILLEY M * * * *32.92
01496 * * * * * SUTTON M * * * *33.00
01496 * * * * * STONE G * * * * 35.99 * *

Hope this makes sense

Many thanks in anticipation

Steve