Setting a dynamic range in a formula

  • Thread starter Thread starter Phillycheese5
  • Start date Start date
P

Phillycheese5

Hi,
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
=(PRODUCT(1+D1:D12/100)-1)*100
Any suggestions?
Thanks,
Phillycheese
 
Assuming that Column D contains no blanks, try...

=(PRODUCT(1+OFFSET(D1,MAX(0,COUNTA(D:D)-12),0,12,1)/100)-1)*100

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
Back
Top