Function CELL in array formulas
Hi all,
yesterday I was trying a solution to a post. It was involving a column
containing dates and percentages. The OP wanted the max of the
non-dates.
I thought I would attack this problem using CELL:
=MAX(IF(LEFT(CELL("format",A1:A5),1)<"D",A1:A5))
It did not work, at least in the array formula. It worked perfectly
when I used an extra column, but this is beside the point. Is it
anywhere stated that CELL cannot be used in array formulas? Am I
missing something?
Regards,
Kostis Vezerides
|