Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with simple data table?
I'm stuck. Using Excel 2002, Win XP Pro
Here's a two-column data table and one column is where I enter a daily number. The next column shows the difference between the present day and the day before as a positive number. Here's the file: http://home.alltel.net/sayres5762/differencechart.xls I'm using =IF(C80,C7-C8,"") to calculate the difference and display a blank if there's no data. The problem is when I must skip a day or two. I want to be able to leave empty cells in Column C and have it not affect the Difference column or the Total Difference. And if the Data entry is blank, I want the Difference to display a blank, as well. On the table enter a number.. say "80" on January 8 and you'll see what I mean. I've learned a few simple formulas but still have a way to go. Any help would be appreciated. Steve |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with simple data table?
Try this in D7, and copy down
=IF(C7="","",INDIRECT("C"&MAX(IF(C$6:C6<"",ROW(C$ 6:C6))))-C7) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Stevie" wrote in message ... I'm stuck. Using Excel 2002, Win XP Pro Here's a two-column data table and one column is where I enter a daily number. The next column shows the difference between the present day and the day before as a positive number. Here's the file: http://home.alltel.net/sayres5762/differencechart.xls I'm using =IF(C80,C7-C8,"") to calculate the difference and display a blank if there's no data. The problem is when I must skip a day or two. I want to be able to leave empty cells in Column C and have it not affect the Difference column or the Total Difference. And if the Data entry is blank, I want the Difference to display a blank, as well. On the table enter a number.. say "80" on January 8 and you'll see what I mean. I've learned a few simple formulas but still have a way to go. Any help would be appreciated. Steve |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with simple data table?
A quick and dirty solution: rather than an empty cell type in the same value
as the day above. Format the cell to hide the data (in your case use yellow font) - this could be done manually of with Conditional Formatting - select C7:C17 and use "Cell formula is" with =C7=C6 and yellow font best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Stevie" wrote in message ... I'm stuck. Using Excel 2002, Win XP Pro Here's a two-column data table and one column is where I enter a daily number. The next column shows the difference between the present day and the day before as a positive number. Here's the file: http://home.alltel.net/sayres5762/differencechart.xls I'm using =IF(C80,C7-C8,"") to calculate the difference and display a blank if there's no data. The problem is when I must skip a day or two. I want to be able to leave empty cells in Column C and have it not affect the Difference column or the Total Difference. And if the Data entry is blank, I want the Difference to display a blank, as well. On the table enter a number.. say "80" on January 8 and you'll see what I mean. I've learned a few simple formulas but still have a way to go. Any help would be appreciated. Steve |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with simple data table?
That did it! Duh.. so simple (*not*) haha
Thanks heaps, Steve "Bob Phillips" wrote in message ... Try this in D7, and copy down =IF(C7="","",INDIRECT("C"&MAX(IF(C$6:C6<"",ROW(C$ 6:C6))))-C7) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Stevie" wrote in message ... I'm stuck. Using Excel 2002, Win XP Pro Here's a two-column data table and one column is where I enter a daily number. The next column shows the difference between the present day and the day before as a positive number. Here's the file: http://home.alltel.net/sayres5762/differencechart.xls I'm using =IF(C80,C7-C8,"") to calculate the difference and display a blank if there's no data. The problem is when I must skip a day or two. I want to be able to leave empty cells in Column C and have it not affect the Difference column or the Total Difference. And if the Data entry is blank, I want the Difference to display a blank, as well. On the table enter a number.. say "80" on January 8 and you'll see what I mean. I've learned a few simple formulas but still have a way to go. Any help would be appreciated. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel |