Bhugz:
It will work as you want. try it out.
The only time it will show a 0 is if the player hasn't played at all in any game (or if their best score actually was 0!)
(and if you want to ignore that, then just setup conditional formatting so a 0 shows as white text or something)
ETA: I just realised it is possible to have a negative score. That screws up the ISERROR part of the calc. sorry. Pivots are your best bet
Yeah I was getting a #Name error with your formula. Is there any other way to do it without using pivot tables, like if i have a helper column or something?
whats wrong with a pivot table? It will make it much easier to add new data.
