Quote Originally Posted by AlanY View Post
that will work if you sorted date first and points;

put =IF(B18<>B19,A18,IF(A18<A19,"-",A19)) into C18 and pull down
Hi Alan,

Thank you very much for taking the time to help me out.

The only problem with that formula is that if the points in A20 than they are in A21 then the Outcome doesn't change to the highest number. Is there any way to convert this?