This screenshot shows a rank calculation on a worksheet.