Thread: Graphing a dynamic range that automatically picks up the most recent entry.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gimiv gimiv is offline
external usenet poster
  
Posts: 1
Default Graphing a dynamic range that automatically picks up the most recent entry.

I have the range working, but the cells in which data has not been
entered into yet has the formula =IF(ISERROR(B52/AE52),"",B52/AE52) in
it because is it autmtically calculating weekly percentages based on
the input of the daily percentages in the "Daily" worksheet. So, the
real problem is creating the dynimic range, but not have the range read
cells without values (but possible has formulas).

Thanks,

Gimi


--
gimiv
------------------------------------------------------------------------
gimiv's Profile: http://www.excelforum.com/member.php...o&userid=35726
View this thread: http://www.excelforum.com/showthread...hreadid=560012

Reply With QuoteReply With Quote