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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
Hi
For the chart use NA() instead of blanks So, for your copy =IF(Sheet1!A1="",NA(),Sheet1!A1) -- Regards Roger Govier Ed wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
Set up Filter (Data-Filter) for you entire range of data
Then select to show all non-blanks in column C Once this is done select the data range and copy-paste to a new sheet. The rows with Column C blank are not selected and do not paste. -- If this helps, please remember to click yes. "Ed" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
I tried this and the blank cells now have #NA in them. When I chart that it
stills leaves a gap between two columns on my chart. "Roger Govier" wrote: Hi For the chart use NA() instead of blanks So, for your copy =IF(Sheet1!A1="",NA(),Sheet1!A1) -- Regards Roger Govier Ed wrote: 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. . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
I tried this but was unable to filter the data. Not sure I understand the
filter process. Also, how do you select all non-blanks? Thanks for your help. "Paul C" wrote: Set up Filter (Data-Filter) for you entire range of data Then select to show all non-blanks in column C Once this is done select the data range and copy-paste to a new sheet. The rows with Column C blank are not selected and do not paste. -- If this helps, please remember to click yes. "Ed" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Skip a cell
I figured out how to filter the data and to select for all non-blank cells
and then copy the data to my chart data spreadsheet. But I continue to add additonal data. Will I have to copy and paste each time I add new data or is there a formula that I can use to automate the process? "Paul C" wrote: Set up Filter (Data-Filter) for you entire range of data Then select to show all non-blanks in column C Once this is done select the data range and copy-paste to a new sheet. The rows with Column C blank are not selected and do not paste. -- If this helps, please remember to click yes. "Ed" wrote: 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. |
Reply |
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 |