This is an array formula that must be entered using ctrl+shift+enter vs just
enter.

=MAX(IF(H2:H22="a",I2:I22))
you would make a list and use below copied down
=MAX(IF($H$2:$H$22=a1,$I$2:$I$22))
or a macro
--
Don Guillett
SalesAid Software

"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
Hi,

Got a list of customers.

Can identify duplicates by address

I only want to keep the highest value customer at each address:

e.g.
Tom 15 Essex Place £30000
Pete 1 George Street £25000
Katy 15 Essex Place £45000
Sally 12 Bath Rd £40000

In the example above, I'd want to pick all entries except the first, as
the
third is the same address and a higher value.

This needn't be complicated - a column of formulas which check all
identical
addresses and only return a "Yes" if the row is the highest value for that
address would be great.

Apologies if this is easy - I played about for ages and just couldn't see
it.

Cheers,

Tom.