Rank by Column Q data first, then by Column L data, then by Column K data to break ties

I'm stuck on ranking with multiple criteria so I'm not left with ties (duplicate ranks).

I've attached a small sample from a larger workbook. The columns with the header in red text (Row 2, columns D, F, G, L,& O) are manual input cells and are going to change. The remaining columns use formulas to automatically populate accordingly. But I'm having trouble creating a working formula in column R.

In column R "Final Portfolio Rank" I want to rank the portfolios by their total points first (column Q), then by the portfolio score (column L), but that still leaves me with ties or duplicate ranks, so I want to break the ties using the final test ranks (column K).

I have Excel 365, but others that need to use this spreadsheet don't. As a result I need the formula to use older functions from earlier versions of Excel (like 2016).

Thanks in advance for any help with this.

Yes, I can insert helper columns if needed. I can always hide them from the participants. However, there is a problem with your solution because row 13 should be ranked 10th, not 11th. A judge will place the top 10 portfolios which are indicated by inputting their selection into column O. The judge should rank the highest score as 1st place and proceed with the next lower score. When two portfolios have the same score, the judge will determine which they like most and award them the placing. For an example, you can see the score on rows 3, 12, 13, & 14 are all 171. Row 3 was selected as 9th place, and row 13 was selected as 10th place. All remaining scores of 171 should be ordered according to who placed highest on the test. So row 12 should be in 11th place, row 14 should be in 12th place, and row 28 should be in 13th place, and so forth.

Try this formula for helper column:

=Q3*10^12+L3*10^8-K3*10^4-O3