Unfortunately I am unable to upload a file i keep getting a error probably my work sytem not allowing it. The formulae above work in exactly the same way as previously.

The problem is that I have within the range of data Mr A, B C D and E the formula suggested is only finding the max number which applies across all Mr A, B C D and E and not just Mr A.

Thanks