Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming a non-blank range from a col containing non-consec. blank c
Excel 2007. I have a column of data containing several blank cells. These
blank cells are spread out all through the column. I want to define a named range that contains only the non-blank cells of this column. I have seen a previous post of how to do this using an array formula, but the solution not only looks cumbersome but doesn't quite appear to do what I'm looking for anyway. This solution was found at cpearson.com/excel/noblanks.htm Does anyone know of a cleaner solution than this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) |