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.