| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find rows matching Max value
I have a spreadsheet in Excel 2002 which has numbers as per sample below
(plus lots of other columns). How do I automatically filter it to show only the (multiple) rows containing the Max value in the Version column for each Agreement Number ? (Version can have different max values for each agreement and number of version rows per Agreement can be different) Thanks Serena Agreement Version 248685 00 248685 00 248685 00 248685 00 248685 01 248685 01 248685 01 248685 01 248685 02 248685 02 248685 02 248685 02 248685 03 248685 03 248685 03 248685 03 248706 00 248706 00 248706 00 248706 00 248726 00 248726 00 248726 00 248726 00 248726 01 248726 01 248726 01 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find next value if rows between are empty? | Excel Discussion (Misc queries) | |||
| Find Matching Text In Col A move to Col B | Excel Worksheet Functions | |||
| Excel find text and copy rows | Excel Discussion (Misc queries) | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| Find duplicate rows and add together | Excel Discussion (Misc queries) | |||
Threaded Mode
