If you want to account for tied values, use the worksheet function RANK together with the correction factor that is suggested in the Help file for RANK.

• 如果希望考虑重复值,请在使用工作表函数RANK的同时,使用帮助文件中所建议的函数RANK的修正因素。