Re: $$Excel-Macros$$ Offset Formula

2012-02-09 Thread Manasa Yes
M(OFFSET(C2,1,2,3,1)) >calculates the total value of a 3-row by 1-column range that is 1 row below >and 2 columns to the right of cell C2. > > > INDIRECT > > www.cpearson.com/excel/*indirect*.htm > > www.contextures.com/xlFunctions05.html > > Regards, > > Sam M

$$Excel-Macros$$ Offset Formula

2012-02-09 Thread Manasa Yes
Dear Team, Good Morning... I would like to thank one and all for excellent tips, advise & timely help on excell really proud to be part of this learning team!! I had joined for MIS Team recently and would like to learn much on excel so joined this group recently - special thanks to Mr. Noora