S
spartanmba
I am sure this is an easy answer for some of you, but I am not sure how to do
this...thanks for your help in advance.
I have an average formula that I would like to dynamically change the number
of rows it averages. For example if I have 25 cells of data, but the user
only wants ten rows for their work. I would have them enter into a cell the
number of points that want averaged and the average formula would dynamically
adjust based upon their entry. I know I need to dynamically create an
address (row and column) information for the forumla, but I am totally lost
on how to do this.
THANKS again!
John
this...thanks for your help in advance.
I have an average formula that I would like to dynamically change the number
of rows it averages. For example if I have 25 cells of data, but the user
only wants ten rows for their work. I would have them enter into a cell the
number of points that want averaged and the average formula would dynamically
adjust based upon their entry. I know I need to dynamically create an
address (row and column) information for the forumla, but I am totally lost
on how to do this.
THANKS again!
John