I have a basic league table column B contains members names, column O contains the points, and column D contains a lower points column which is made up into the overall column o points


i have the following formula which i have used to sort in desc order some scroe figures


=IF(ISNUMBER(SMALL($O$5:$O$30,ROW()-ROW($O$5)+1)),LARGE($O$5:$O$30,ROW()-ROW($O$5)+1),"")

This sorts the high scores into descending oredr but i'd like to rank the scores in name order. If a score is the same then i'd like the names with the same points to be ranked by column b (highest being best) and then if the same in name order.

not sure how to go about this next bit?