| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Unique Consecutive Duplicate Values across Single Row | Excel Worksheet Functions | |||
| Return Unique Duplicate Numeric Values across Single Row | Excel Worksheet Functions | |||
| Return Numeric Labels that have Values =4 across Single Row | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Return Single Instance of Numeric Values from a Column | Excel Worksheet Functions | |||
Threaded Mode
