LinkBack URL
About LinkBacks
roxrocks 
Hi roxrocks
The problem is that Counta() includes cells with empty strings in the count.
Try instead:
=OFFSET(Page!$A$3,0,0,ROWS(Page!$A$3:$A$100)-COUNTBLANK(Page!$A$3:$A$100),1)
Adjust the last row if you think the data can ever go beyond row 100.
Hi roxrocks
The problem is that Counta() includes cells with empty strings in the count.
Try instead:
=OFFSET(Page!$A$3,0,0,ROWS(Page!$A$3:$A$100)-COUNTBLANK(Page!$A$3:$A$100),1)
Adjust the last row if you think the data can ever go beyond row 100.
Last edited by lecxe; 02-07-2008 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks