Hi
One way
=INDEX(Yearly!$CX:$CX,COUNTA(Yearly!$CX:$CX)-10):INDEX(Yearly!$CX:$CX,COUNTA(Yearly!$CX:$CX))

--
Regards
Roger Govier

"yak141" wrote in message
...
I know how to setup a dynamic range. However, I need a set of formula
that'll
allow the dynamic range to always use the last 10 rows on data in that
range.
My current set of formula is
"=OFFSET(Yearly!$CX$2,0,0,COUNTA(Yearly!$CX:$CX),1 )". It allows me to use
the
entire range, but I only need the last 10 rows. Please help!Thanks