| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
How do I skip a blank cell? I have a column of dates (Col A) and a column of
numbers (Col C). Col C has irregular blanks. I want to copy these to another spreadsheet without the blanks in Col C and without the corresponding dates in Col A. My purpose is to creat a column chart without the gaps caused by blank cells. The IF function will return a blank for a blank but I want to skip the blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does my tab key skip to next page instead of next cell | Excel Discussion (Misc queries) | |||
| Excel 2003-skip to another cell upon leaving | Excel Discussion (Misc queries) | |||
| In Excel, how do I set a formula to skip a cell if zero? | Excel Discussion (Misc queries) | |||
| skip to next cell if no value is found | Excel Discussion (Misc queries) | |||
| Skip a cell that contains data | Excel Worksheet Functions | |||
Threaded Mode
