fyi rank on third sheet is all over the place ,has someone been sorting or something? shouldnt it be
=IFERROR(RANK(A6,$A$6:$A$70,0),"") filled down?