How to Calculate How Much You Can Borrow Using Excel. How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest ...

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.

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.