| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excell 2003 -how to use a scroll bar to adjust the range of a func
i have several statistics functions covering a long list of data (around 1
column by 4600+ rows) i want to use a scroll bar to change the range that the functions compute. example - AVERAGE(A1:A4600) to AVERAGE(A1:A100) i want to be able to slide the scroll bar and shorten the range from 4600 to about 100 or go anywhere in between to see how the average changes from the long term to the short term. any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Scroll down in Excell | Excel Discussion (Misc queries) | |||
| Excell Spreadsheet stuck on scroll | Excel Discussion (Misc queries) | |||
| Right clicked range highlights in Excel would add the "$" to func | Excel Worksheet Functions | |||
| Sum func. is adding cells not in specified range | Excel Worksheet Functions | |||
| How do I insert a scroll bar into the excell sheet? | Excel Worksheet Functions | |||
Threaded Mode
