| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
From range and criteria select highest value
Hello from Sunny RSA,
I have the following database: Unit Kilometers 98R01 109145 06R02 134873 06R02 129523 98R01 110987 07T03 98654 07T03 101345 Now I need a formula that will go and pick the highest kilometers to populiate the following table: 98R01 06R02 07T03 The result should be 98R01 110987 06R02 134873 07T03 101345 The unit numbers are unique, there is no between themselves. I think MAX needs be used, but I am not sure how to apply this to a criteria. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto select highest 25 scores. | Excel Worksheet Functions | |||
| select highest value | Excel Worksheet Functions | |||
| How-to automatically select and chart the highest 10 totals? | Excel Discussion (Misc queries) | |||
| date criteria to select range | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Threaded Mode
