Hello,

I am preparing a scoring sheet of multiple RAG (red,amber,green) categories which will be filled in for multiple team members on a weekly basis. Not all team members will have their row completed each week, and not all categories will be filled in for a member when they are scored.

I want to have a summary sheet which looks across all the other sheets and pulls back the most recently entered category value "R", "A" or "G". If no category value has ever been entered for that member then return a blank.

Help much appreciated

Cormac