Error #NUM! - Array Formula

Hi,

Same formula using, why error #NUM! was appear?


TEXT(MAX(IF(A351:A356=C355&1,B351:B356)),"dd.mm.yyyy")
Correct result

TEXT(MAX(IF('FD '!A:A='Welfare AN'!B9&2,'FD '!B:B)),"dd.mm.yyyy")
Result = #NUM!

Thanks

Obvious, you tried to apply your array formula to entire columns.

You do understand how an array works, right? EVERY CELL in the range is evaluated individually for the complete instruction, even if a cell is found that resolves it, it keeps going. So in Excel2003 that means your function, applied to an entire column, would try to calculate 65536 separate calcs per cell that had this formula.

You would most likely crash your computer if Excel allowed this.

Apply your array to a reasonable number of rows.