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