ERROR=#VALORE!


Rick Rothstein (MVP - VB) wrote:
Give these a try...

Maximum....
=TEXT(SUMPRODUCT(MAX((D1:D1000="4580")*A1:A1000)) ,"@")

Minimum...
=TEXT(10000-SUMPRODUCT(MAX((D1:D1000="4580")*(10000-A1:A1000))),"@")

Rick

Tks Bob...
But work only if the column A and D are in General or number, my two
[quoted text clipped - 22 lines]
6843 0580
6846 0580

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200709/1