I wonder if you can help with this puzzle.
I have a list of tasks in excel, and each task has a RAG (Red/Amber/Green) status
I would like excel to determine my 'overall' status based on the status that is most prevellent from the list of task statuses (is that a word?)
I can't think of a good way of doing this, I tried to give a weight to each task and score the result but I dont think will work well.
Can you help? I have attached a spreadsheet that should help explain what I mean