Hi Pecoflyer
Under normal circumstances I would be happy to share the solution for the benefit of other Forum Users but due to the extreme sensitivity of the work I am doing I am unable to on this occassion. What I did was to slightly redesign the worksheet and use a series of more basic functions in order to achieve my desired end result.
Thanks
Tony