Try:

=MAX((A2:A4000=123)*(B2:B4000))

Array entered by holding Crtl & Shift pressed while you press Enter or:

=SUMPRODUCT(MAX((A2:A4000=123)*(B2:B4000)))

Entered with just a simple enter

But lookout for Harlan! (in joke with Harlan)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Hugo C." wrote in message
...
i´m trying to obtain the max value, but i need to have a reference
ex:

client value
123 1560
123 2000
123 8520
156 1564
154 4666

I need to group client 123 in order to obtain is max value - 8520

Can someone please help me (it´s a list of 40000 clients, and i don´t want
to do manualy)