I have attached an example of what I am trying to do with comments on the actual spreadsheet. Please see sheet 2 for the example and comments. Could whoever helps me please tell me how to create the macro or excel forumla as this may not be the final layout and the data is all made up at this stage so I need to be able to amend the coding/forumlas if required.
Thanks.
(ps this is on excel 2010)
Bookmarks