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
|