Those of us who use Jet Reports are painfully aware that Jet does not have a ranking feature for replicated lists. However, there is a workaround: you can create an automatically sorted Jet report with nested Jet functions and use Excel’s rank function to give you a ranked Jet report. This blog will walk through the steps to do just that.