| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range | Setting up and Configuration of Excel | |||
| Dynamic range in chart | Charts and Charting in Excel | |||
| Dynamic range | Charts and Charting in Excel | |||
| Chart attached to dynamic range | Charts and Charting in Excel | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Threaded Mode
