Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions |