Hi Priyanka..
Offset Function
The OFFSET function is used to return the address of a cell or a range of
cell through the use of a reference cell. If we know the cell or range
beforehand, we are unlikely to use it at all. It is very useful in our
spreadsheets when we do not know the cell or the ra
Kindly let know the usage of Offcet and indirect formual
For which purpose we are using the same
And how we can use large formula with sum (to get sum from sheet2 to sheet1
for highest 5 amounts )
On Thu, Feb 9, 2012 at 11:06 PM, NOORAIN ANSARI wrote:
> Hi Maansi,
>
> you are welcome in Excel-M
Dear Mr.Sam & Mr.Noorain...
Many Thanks for this wonderful examples & advise :-)
I will go throug it and if i find dificulty, will revert with the problem.
Have a great day!!
Maansi
On Thu, Feb 9, 2012 at 11:03 PM, Sam Mathai Chacko wrote:
> http://support.microsoft.com/kb/324991 (OFFSET)
>
Hi All,
Its nice staff do you have this in English it looks great but I don't get a
word from it :)
Regards,
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Thursday, February 9, 2012 5:36 PM
Subject: Re: $$Excel-Macros$$ Offset Fo
http://support.microsoft.com/kb/324991 (OFFSET)
Description
Returns a reference to a range that is a specified number of rows and
columns from a cell or range of cells. The reference that is returned can
be a single cell or a range of cells. You can specify the number of rows
and the number of co
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
