Array Formula

Dear Experts,

Please find the following formula
=LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC.D ATE,0),1).

how to make the result (AND(AC.TR,NMT = "X1234"), AC.STATUS-1) as Array
Result?

because if i do "EVALUATE FORMULA" it will result either 0 or 1.
Where we would like the result as Array e,g {0,0,0,1,1,0...) to match the
records of AC.DATE.

thank you for your kind help and guidance.

TIA.

respectfully,
andri

=LARGE(IF((Range1=criteria1)*(Range2=criteria2),Da teRange))

ctrl+shift+enter, not just enter


"Andri" wrote:

Dear Experts,

Please find the following formula
=LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC.D ATE,0),1).

how to make the result (AND(AC.TR,NMT = "X1234"), AC.STATUS-1) as Array
Result?

because if i do "EVALUATE FORMULA" it will result either 0 or 1.
Where we would like the result as Array e,g {0,0,0,1,1,0...) to match the
records of AC.DATE.

thank you for your kind help and guidance.

TIA.

respectfully,
andri

=LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC. DATE,0),1).

MAX(....) does the same thing as LARGE(...,1)

Try it like this (array entered**):

=MAX(IF(AC.TR.NMT="X1234",IF(AC.STATUS=1,AC.DATE)) )

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Andri" wrote in message
...
Dear Experts,

Please find the following formula
=LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC.D ATE,0),1).

how to make the result (AND(AC.TR,NMT = "X1234"), AC.STATUS-1) as Array
Result?

because if i do "EVALUATE FORMULA" it will result either 0 or 1.
Where we would like the result as Array e,g {0,0,0,1,1,0...) to match the
records of AC.DATE.

thank you for your kind help and guidance.

TIA.

respectfully,
andri

Hello Andri,

If you need your results for all possible values of AC.TR.NMT you
might want to consider using my UDF Pstat:
http://sulprobil.com/html/pstat.html

Regards,
Bernd