I'm currently using the following RANK code to automatically sort a table depending on score. Should the scores be identical I then need to sort on the next bit of data. If they are identical the same for a third row. Is it possible?

=IF('Leader Board Data'!F7="","",RANK('Leader Board Data'!F7,'Leader Board Data'!F$7:F$17,1)+ROW()/100000)
Thanks in advance!!