Monthly Archives: May 2014

“Excel, did you know?” Tip#5

“Excel, did you know?” that sparklines can use formulas such as =OFFSET($A$1,1,$G$1,COUNTA($A:$A)-1,1), when created as defined name formulas, as their input range.

Advertisements