percentages in '07 running vista

[johngoat]

hello & good day. i have 2 columns of stock prices. C1toC33 and D1toD33.
col C is highest price of day, col D is lowest price of the day.

from col C
todays price is higher than what % of the past x-number of days prices?
want to print daily answer to corresponding row in col H.

from col D
todays price is lower than what % of the past x-number of days prices?
want to print daily answer to corresponding row in col I.

in both cases i need to know how to adjust how many days it looks back.

ex: row 1 is today's price data. using data from C1toC10, print in cell I1.
hopefully this is clearly worded. i thank you in advance for the help.

 

[EXCEL-lence]

Hi,

You'll need to be looking at dynamic ranges for this, or use of the OFFSET function

Am I right in thinking that you only have 33 days of data?

 

[johngoat]

i now have 33 days history, but going forward i'll just be adding each new day at the
top of the column and "shift down" the rows. it is extremely tedious to enter the data.
i don't suppose there is a way to have excel find each day's data? it is important that i know how to adjust the look back period. thank you for your help, cheers