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