How to flip the ranked results in Microsoft Excel Earlier, I mentioned that RANK.EQ () has an optional argument to determine the sort.

Microsoft Excel will rank whatever you want automatically. Susan Harkins will show you how.