Hi,

Can this be done?

I have a list of registrations with a mileage from external source
EG

Reg Mileage

aa01 1000
aa01 2000
aa01 3000
aa01 4000
bb02 1001
bb02 2001
bb02 3001
bb02 4001
cc03 1002
cc03 2002
cc03 3002
cc03 4002

What i need to be able to do is select the hightest Mileage record from
each unique reg

So the output needs to look like

aa01 4000
bb02 4001
cc03 4002

Make sense? This report needs to be run once a month for 50 different
accounts, so I need some sort of macro, or automatic feature that even
the stupidest of people can use...


--
Odysseus
------------------------------------------------------------------------
Odysseus's Profile: http://www.excelforum.com/member.php...o&userid=14563
View this thread: http://www.excelforum.com/showthread...hreadid=320085