Let's say start dates are in B and finish dates are in C. In K6, the formula will be : =IF(C6="",NA(),C6-B6) Copy downward Daniel
-----Message d'origine----- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Joni Childers Envoyé : mardi 7 juin 2011 23:46 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Defining Names & Charting OK... I've a problem. I've got the "gist" of this... but it's just not working for me. In worksheet 'Source Data', in Cell A5 is the Title for "A" Column .. DEMO PROJECT, and subsequent data beneath that (starting A6)... (These are addresses). There are some data in columns B-K, but don't want these included on my chart. In same worksheet in K5 is the Title "Days from Start to Finish", and subsequent data beneath that (this # comes from a formula that subtracts one date from another). Here's the kicker, there will at one time be 100+ addresses (or projects) in column A, some of which may not have a finish date, hence, having no data in the K Column. For example, I may have data in Column A6:A75, BUT only data in Column K6, K16, K23, K24, K40, K45, K61, K70, K71, K72... I want to chart these... But, I want to chart without having to REchart every time I add new data... Does this make sense to you???? Please help! Excel 2007 -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
