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