geospatial
Active Member
- Joined
- Sep 2, 2008
- Messages
- 290
The issue is that one of my dynamic ranges worked fine using the formula =offset(Master!$A$1,0,0,counta(Master!$A:$A),1). Then I created another dynamic range on column B with =offset(Master!$B$1,0,0,counta(Master!$B:$B),1) and while it does select a lot of data it doesnt select the entire column. Currently leaving off around 500 cells in that column. There is no empty or hidden cells.
Not sure why its doing this.
Also another question would be how to redo the abover formula if I wanted to start in row 2 of a column instead of row 1. I know it would look like this =offset(Master!$A$2,0,0,counta(Master!$A:$A),1), but the problem I have is that it then also selects one empty cell below the last bit of data which adds in a blank for my data.
Not sure why its doing this.
Also another question would be how to redo the abover formula if I wanted to start in row 2 of a column instead of row 1. I know it would look like this =offset(Master!$A$2,0,0,counta(Master!$A:$A),1), but the problem I have is that it then also selects one empty cell below the last bit of data which adds in a blank for my data.
