Hi, I posted here yesterday so apologies for the two posts in two days - I am trying to do this independently I am just struggling with the really big formulas.
The attached workbook explains the problem however here is a brief overview:
I'm trying to return a number value from one sheet to another.
This issue lies as I am trying to return these by names on one sheet into the correct location on the next sheet. However one persons name can appear multiple times and I am struggling to get the last value each time.
The spreadsheet explains the problem better as its much more visual.
I hope someone can help and thanks in advance for any time this may take.
Matthew
Bookmarks