more rows error

[Desperate]

How can I correct the error *** # more rows*** when it appears in an array?
where # is an actual number. I have tried to drag the formula down with no
results.

 

[ShaneDevenshire]

Hi,

Please show us the formula that is causing the problem. Also are you seeing
#'s or *'s? # signs often mean the column is too narrow, but other things
can cause this.