One quick alternative is to use a pivot table (PT). In a matter of seconds,
the PT can provide both the required uniques listing of the Clients and the
corresponding max values

Select any cell within the source table. Click Data PivotTable .. Click
Next Next. In step 3 of the wizard, click Layout. Drag n drop Client within
the ROW area. Drag n drop Value within the DATA area. It'll appear as "Sum of
value". Double click on it, choose "Max" under Summarize by, click OK. Click
Finish. That's it! Hop over to the PT sheet for the results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hugo C." wrote:
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)