| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference
In the formula:
=AVERAGE(A1:A13) I would like to be able to change the 13 to other values from a single cell located in a different part of the spreadsheet by just entering a different number in that cell. In other words to change the range from separate cell. Can I do that without using a macro....kinda new at this. Many thanks. Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Help with Range Reference | Excel Programming | |||
| Can you get the range reference for each page in a worksheet print range? | Excel Programming | |||
| adding reference-to-range control to excel range | Excel Programming | |||
| Subscript out of Range on Range reference | Excel Programming | |||
Threaded Mode
