If you are saying that you want the max value in col G based on the client
in col F then use this formula which must be entered using ctrl+shift+enter
=MAX(IF(F2:F22=123,G2:G22))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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)