It's often easier to help based on a sample sheet, being that I don't like typing unnecessarily.
Based on the attached you might be able to solve your problem

Attached Files

Max example.xlsx (11.6 KB, 11 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Both
Many thanks for the responses. I have just resolved my issue with help from a colleague.
Kind regards
Tony

Care to share your solution?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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