Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Help with simple data table?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stevie - 28 Jan 2006 13:42 GMT
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(C8>0,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
Bob Phillips - 28 Jan 2006 15:16 GMT
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)

> I'm stuck.  Using Excel 2002, Win XP Pro
>
[quoted text clipped - 20 lines]
>
> Steve
Stevie - 28 Jan 2006 15:53 GMT
That did it!  Duh..    so simple (*not*)  haha

Thanks heaps,
Steve

> Try this in D7, and copy down
>
[quoted text clipped - 38 lines]
>>
>> Steve
Bernard Liengme - 28 Jan 2006 15:29 GMT
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
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> I'm stuck.  Using Excel 2002, Win XP Pro
>
[quoted text clipped - 20 lines]
>
> Steve
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.