When you say:
no blanks, no empty text
Expected Results:
104, 150, 179
Using a formula the results would be:
| 104 | 150 | 179 | "" | "" | "" | "" | "" |
Where "" is a blank cell. The cell will contain the formula but return a
blank.
If that's unacceptable then you'll need a macro to do this and you should
post in the programming ng.
Like I said before, Sam's posts are *always* the most complicated posts, bar
none! <g
--
Biff
Microsoft Excel MVP
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:7f7153aa1924e@uwe...
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