On 2002-10-21 17:44, ehsas wrote:
=OFFSET(sheet1!$A$6,0,3,1,COUNTA(sheet1!$D$6:$Z$6)
I manage to make the above formula which refers to the row 6 in my worksheet.The only problem which I don't understand.I want the formula to take last 13 fields of row 6 instead of d6 to z6.Please if any one could help.Regards.
On 2002-10-22 07:52, ehsas wrote:
it starting from d6 till ak6. which i want to take last 13 months.It is month like jan'01,feb'01 and so on.Please if some one could help me.Regards,