=offset ???

[myeaddress2003]

Plz tell me what for OFFSET function is used and what is the diffrence etween OFFSET and SERIAL

plz explain by any example Thanks

[Bob Phillips]

If you look at Help in Excel, there is a topic on the OFFSET Worksheet
Function.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"myeaddress2003"
<[email protected]> wrote in
message news:[email protected]...
>
> Plz tell me what for OFFSET function is used and what is the diffrence
> etween OFFSET and SERIAL
>
> plz explain by any example Thanks
>
>
> --
> myeaddress2003
> ------------------------------------------------------------------------
> myeaddress2003's Profile:
http://www.excelforum.com/member.php...o&userid=36356
> View this thread: http://www.excelforum.com/showthread...hreadid=561435
>

[tony h]

The Excel help function is very informative.
If you use the search function on this site you will find plenty of examples.

[bj]

the offset function allows you to specify a range or cell based on the
location of a specific cell. there is a fair description of it in the help
section.

I have no idea what SERIAL refers to.

"myeaddress2003" wrote:

>
> Plz tell me what for OFFSET function is used and what is the diffrence
> etween OFFSET and SERIAL
>
> plz explain by any example Thanks
>
>
> --
> myeaddress2003
> ------------------------------------------------------------------------
> myeaddress2003's Profile: http://www.excelforum.com/member.php...o&userid=36356
> View this thread: http://www.excelforum.com/showthread...hreadid=561435
>
>

[R..VENKATARAMAN]

in any empty cell if you type

=offset(a1,1,2) means
the value of that cell counting from A1 one row down and 2 columns to the
right i.e. C2

offset can also be used din vba

============


"myeaddress2003"
<[email protected]> wrote in
message news:[email protected]...
>
> Plz tell me what for OFFSET function is used and what is the diffrence
> etween OFFSET and SERIAL
>
> plz explain by any example Thanks
>
>
> --
> myeaddress2003
> ------------------------------------------------------------------------
> myeaddress2003's Profile:
> http://www.excelforum.com/member.php...o&userid=36356
> View this thread: http://www.excelforum.com/showthread...hreadid=561435
>