I have never liked the COUNTA method for getting such a dynamic range. I prefer something like xld has here: http://www.xldynamic.com/source/xld.LastValue.html