Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
Hi all, I am trying to tweek the offset function in an effort to make it more effective for my particular worksheet. I require the details in a cell positioned to the left of the current cell, whos position is determined by another cell. Eg Cell A1 Contains '4 months' and the '4' determines information about the Offset function.... the layout being shown below. Name' Months' Jan - Dec' Total' 'Blank' Jan-Dec' Total' The offset works fine during the period between Jan - Dec HOWEVER because of the total and blank columns (required) I need to make small adjustements so that Offset picks the correct information (Eg +2 etc to miss blank and total). I would like to have some intelligence in this equation so that it can be made more universal. Any help would be much appreciated! Cheers J -- jagbabbra ------------------------------------------------------------------------ jagbabbra's Profile: http://www.excelforum.com/member.php...o&userid=32525 View this thread: http://www.excelforum.com/showthread...hreadid=542827 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
offset function | About this forum | |||
clock | Excel Worksheet Functions | |||
offset function | Excel Worksheet Functions |