Facebook Twitter Google+ RSS Sitemap

Tuesday, June 11, 2013

QA: Useful excel formula


  • Define array (automatically detect the last row)
  • =OFFSET(ACTUAL_RESULTS!$A$3,0,0,COUNTA(ACTUAL_RESULTS!$B:$B)+100,COUNTA(ACTUAL_RESULTS!$3:$3))

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)