Hi All,

I am using following formula to show dynamic range but for some reason, when i click on the Name ranges, it is showing extra two row as it can be seen in the picture below.

Wondering is there anything i am missing in this formula?

=OFFSET('Training Plan'!$A$5,0,0,COUNTA('Training Plan'!$A:$A),1)
dynamic range.jpg