This screenshot shows a worksheet containing a rank function.