00-Jan-00

[Taka83]

Hi all,

I would appreciate some advice on the below formula. I am looking to remove the answer 00-Jan-00 which is returned when there is no match for the formula to in the array. Is there anyway of replacing 00-Jan-00 with a blank cell?

=INDEX(,MAX(IF(COLUMN())))

Thanks in advance!

 

[Weaver]

Would it help to use conditional formatting to set the text of the cell to white if the cell value is zero?