| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula that returns Col A data in Col B, but omitting blank cells
I would like to convert data in Col A to a format in Col B, so that Col B
omits the blank cells in Col A. Is this possible with a formula I can drag down? For example: Col A Col B 1 1 2 2 34 34 5 5 6 9 6 7 9 7 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
| Importing Data Into Formula Based Cells | Excel Worksheet Functions | |||
Threaded Mode
