Formula Help
=OFFSET(Daily!$A$1,0,0,1,COUNTA(Daily!$1:$1)-1)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Abdul" wrote in message
ups.com...
Hi all,
The following formula i use to name a range so when ever i add data to
column A the range is automatically adjusted.
=OFFSET(Daily!$A$1,1,0,COUNTA(Daily!$A:$A)-1)
now how I cud I modify this formula to get a dynamic range on Row 1
($1:$1)
thanks
|