| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a range "dynamic"?
"Biff" wrote: It elimnates the '9.9999999999999E+307' that I know Biff likes so much <bg argh! <vbg Biff wrote in message ... Another option Don't worry about using B1 and =Sum(B:B)-Sum(B1:B22) It elimnates the '9.9999999999999E+307' that I know Biff likes so much <bg Cheers RES |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
