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