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