For next time this will be fixed. I had it set to conditionally format bold the top 3 figures but I did it using the LARGE function. Unfortunately, I now realize that it finds the third largest number, not the third RANKED number, so ties in aren't counted.
I've changed it up using RANK and now just the three best figures will be highlighted.
|