This screenshot shows the a table worksheet with a RANK calculation item.