In a worksheet an array formula fetches me 0 to 10 results which occupies 0
to 10 rows which includes results plus error #N/A.I have five formulas like
this.I would like to join these five formulas output in such way to get the
results serially in a row eliminating errors or leaving blank rows.suppose in
one case formula 1 results (only) occupies 4,formula 2 results should fetch
its results from 5th row onwards.I have 2 other formulas that teels me how
many rows a formula occupies and combinedly how many rows these 5 formulas
occupy.Is it possible to do this task.