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
"gssitaly via OfficeKB.com" <u13846@uwe wrote in message
news:7792712991837@uwe...
Tks Bob...
But work only if the column A and D are in General or number, my two
column
are in Text format, and not work?! in other case how to stora the the
result
in variable if i use a formula?
Bob Phillips wrote:
=MIN(IF(D1:D100=4552,A1:A1000))
and
=MAX(IF(D1:D100=4552,A1:A1000))
which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets),
do
not try to do this manually.
When editing the formula, it must again be array-entered.
in column A have a value related column D.
In effect in D are the value of Principal Agency and in column A are the
[quoted text clipped - 153 lines]
6843 0580
6846 0580
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200709/1