canthony24
Board Regular
- Joined
- Mar 24, 2016
- Messages
- 70
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?
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?