News

First, we will calculate the GCD, then we will use this GCD value to calculate the ratio. Select the cell in which you want to display the GCD. In our case, it is the cell C2.
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions of the .xlsx format through 2007. Excel for the web supports PivotTable objects.
A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.