software

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:
home.alltel.net/sayres5762/differencechart.xls

I'm using =IF(C8gt;0,C7-C8,quot;quot;) 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 quot;80quot; 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
Try this in D7, and copy down

=IF(C7=quot;quot;,quot;quot;,INDIRECT(quot;Cquot;amp;MAX(IF(C$6:C6lt;gt;quot;quot;,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)

quot;Steviequot; gt; wrote in message
...
gt; I'm stuck. Using Excel 2002, Win XP Pro
gt;
gt; Here's a two-column data table and one column is where I enter a daily
gt; number. The next column shows the difference between the present day and
gt; the day before as a positive number.
gt;
gt; Here's the file:
gt; home.alltel.net/sayres5762/differencechart.xls
gt;
gt; I'm using =IF(C8gt;0,C7-C8,quot;quot;) to calculate the difference and display a
gt; blank if there's no data.
gt;
gt; The problem is when I must skip a day or two. I want to be able to leave
gt; empty cells in Column C and have it not affect the Difference column or
the
gt; Total Difference. And if the Data entry is blank, I want the Difference
to
gt; display a blank, as well.
gt;
gt; On the table enter a number.. say quot;80quot; on January 8 and you'll see what I
gt; mean.
gt;
gt; I've learned a few simple formulas but still have a way to go. Any help
gt; would be appreciated.
gt;
gt; Steve
gt;
gt;
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
quot;Cell formula isquot; with =C7=C6 and yellow font
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Steviequot; gt; wrote in message
...
gt; I'm stuck. Using Excel 2002, Win XP Pro
gt;
gt; Here's a two-column data table and one column is where I enter a daily
gt; number. The next column shows the difference between the present day and
gt; the day before as a positive number.
gt;
gt; Here's the file:
gt; home.alltel.net/sayres5762/differencechart.xls
gt;
gt; I'm using =IF(C8gt;0,C7-C8,quot;quot;) to calculate the difference and display a
gt; blank if there's no data.
gt;
gt; The problem is when I must skip a day or two. I want to be able to leave
gt; empty cells in Column C and have it not affect the Difference column or
gt; the Total Difference. And if the Data entry is blank, I want the
gt; Difference to display a blank, as well.
gt;
gt; On the table enter a number.. say quot;80quot; on January 8 and you'll see what I
gt; mean.
gt;
gt; I've learned a few simple formulas but still have a way to go. Any help
gt; would be appreciated.
gt;
gt; Steve
gt;
That did it! Duh.. so simple (*not*) haha

Thanks heaps,
Stevequot;Bob Phillipsquot; gt; wrote in message
...
gt; Try this in D7, and copy down
gt;
gt; =IF(C7=quot;quot;,quot;quot;,INDIRECT(quot;Cquot;amp;MAX(IF(C$6:C6lt;gt;quot;quot;,ROW(C$ 6:C6))))-C7)
gt;
gt; which is an array formula, it should be committed with Ctrl-Shift-Enter,
gt; not
gt; just Enter.
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Steviequot; gt; wrote in message
gt; ...
gt;gt; I'm stuck. Using Excel 2002, Win XP Pro
gt;gt;
gt;gt; Here's a two-column data table and one column is where I enter a daily
gt;gt; number. The next column shows the difference between the present day and
gt;gt; the day before as a positive number.
gt;gt;
gt;gt; Here's the file:
gt;gt; home.alltel.net/sayres5762/differencechart.xls
gt;gt;
gt;gt; I'm using =IF(C8gt;0,C7-C8,quot;quot;) to calculate the difference and display a
gt;gt; blank if there's no data.
gt;gt;
gt;gt; The problem is when I must skip a day or two. I want to be able to leave
gt;gt; empty cells in Column C and have it not affect the Difference column or
gt; the
gt;gt; Total Difference. And if the Data entry is blank, I want the Difference
gt; to
gt;gt; display a blank, as well.
gt;gt;
gt;gt; On the table enter a number.. say quot;80quot; on January 8 and you'll see what I
gt;gt; mean.
gt;gt;
gt;gt; I've learned a few simple formulas but still have a way to go. Any help
gt;gt; would be appreciated.
gt;gt;
gt;gt; Steve
gt;gt;
gt;gt;
gt;
gt;