| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
