=offset ???
 

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

=offset ???
 

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"
<myeaddress2003.2axotq_1152878109.1134@excelforu m-nospam.com wrote in
message news:myeaddress2003.2axotq_1152878109.1134@excelfo rum-nospam.com...

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

=offset ???
 

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"
<myeaddress2003.2axotq_1152878109.1134@excelforu m-nospam.com wrote in
message news:myeaddress2003.2axotq_1152878109.1134@excelfo rum-nospam.com...

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

=offset ???
 

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

=offset ???
 

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=561435