Offset,counta

[canthony24]

My dynamic range always has a blank row at the end of the range when I select the formula. I currently have =OFFSET('Source Data'!$A$2,0,0,COUNTA('Source Data'!$A:$A),82)

When I click the formula and scroll to the bottom of the data, there is always a blank row. Example, if my data set runs down to row 54105, the dynamic formula captures 54106 and it's always blank.

Ideas?

 

[KevCarter]

Please try:

=OFFSET('Source Data'!$A$2,0,0,COUNTA('Source Data'!$A:$A)-1,82)

 

[canthony24]

Ah got it. Thanks!

 

[KevCarter]

Happy to help. Cheers!