| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I remove blanks from a range without using sort?
I have a range of cells A1:a10, say, which obtain data from another source.
Some of those cells a3, a6:a8, say, under certain conditions, will be blank. How do I reorder this range such that the cells containing information are listed together, removing the blanks? I want to do this using a formula, rather than filter or sort, as the data, and hence the blank cells, will change, and I want to perform analysis on the cells containing data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct of part cells of a range with blanks | Excel Discussion (Misc queries) | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| remove blanks from a string of chars within a cell? | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Threaded Mode
