HI I am using a spreadsheet over several sheets to show a statement of account.

I can use:{=IF(Order!C2:C23="n",Order!B2:B23,0)} to produce an array that
checks column C for an "n" and displays the date (unpaid invoice date as it
happens) from column B. A zero is inserted if there is no "n"

I would like to know if there is a way to ONLY display the non-zero cells:
12/12/09
14/12/09 etc rather than

0
0
12/12/09
0
0
0
14/12/09

That is showing at the moment.

Many thanks in advance for any helpful suggestions - bit of a novice in over
my head!

Bullytt