Hi All,

I have an array of data in a single row that includes numeric and #N/A values.

I would like to return only the numeric values of the formula based array to
consecutive cells in a single row; without: empty text, blanks or #N/A values
in any of the returned cells.

Sample Data:
Row 50, column "C" to column "AG".

Column C, D, E, F, G, H, I, J
Row50 #N/A, #N/A, #N/A, 104, #N/A, 150, 179 #N/A


Expected Results:
104, 150, 179

Expected results returned to consecutive cells in a single row (no blanks, no
empty text, no #N/A).

Cheers,
Sam

--
Message posted via http://www.officekb.com