=offset ???

  • Thread starter Thread starter myeaddress2003
  • Start date Start date
M

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
 
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"
 
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"
 
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.
 
The Excel help function is very informative.
If you use the search function on this site you will find plenty of
examples.
 
Back
Top