T
tbraddy
I have some data that is listed in the lower portion of a worksheet
(rows 201+) and want to grab it based on user input into a cell. I
also want to calculate an average of that data.
ie
Value
Start 30 lookup value for 30
End 60 lookup value for 60
Average calculate average for 30-60
Is there a way to say =B(200 + value of Start), =B(200+End),
=average(B(200+start):B200+end))?
I could just do it =B230 =B260 =average(B230:B260), but having it
update would be much easier
I can do a lookup on the Start and End data, but the average is not as
easy.
Thanks Todd
(rows 201+) and want to grab it based on user input into a cell. I
also want to calculate an average of that data.
ie
Value
Start 30 lookup value for 30
End 60 lookup value for 60
Average calculate average for 30-60
Is there a way to say =B(200 + value of Start), =B(200+End),
=average(B(200+start):B200+end))?
I could just do it =B230 =B260 =average(B230:B260), but having it
update would be much easier
I can do a lookup on the Start and End data, but the average is not as
easy.
Thanks Todd