How can I use Rank.Eq, Countifs, and Offset to Rank a Filtered Table

[ja4day]

[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD]Language
[/TD]
[TD]Criteria1: Wait time(min)
[/TD]
[TD]Criteria2: Success Rate
[/TD]
[TD]Criteria3: Volume
[/TD]
[/TR]
[TR]
[TD]EN
[/TD]
[TD]30.5
[/TD]
[TD]61.5%
[/TD]
[TD]200000
[/TD]
[/TR]
[TR]
[TD]EN
[/TD]
[TD]70.0
[/TD]
[TD]75.3%
[/TD]
[TD]4765
[/TD]
[/TR]
[TR]
[TD]SP
[/TD]
[TD]10.0
[/TD]
[TD]57.34%
[/TD]
[TD]8000
[/TD]
[/TR]
[TR]
[TD]SP
[/TD]
[TD]47.0
[/TD]
[TD]49.6%
[/TD]
[TD]2000
[/TD]
[/TR]
[TR]
[TD]SP
[/TD]
[TD]47.0
[/TD]
[TD]55.81%
[/TD]
[TD]310000
[/TD]
[/TR]
</tbody>[/TABLE]

I've been all over this forum and google trying to find out how to dynamically rank a filtered table w/ multiple conditions. I've seen ways to do one or two parts, but not all.

I'd like to rank by the criteria, in respective order, but use language as the filter. Expected result below...

---

Rank | Lang | Crit1| Crit2| Crit3
1 | EN |70.0 |75.3% | 4765
2 | SP | 47.0 |55.81% | 310000
3 | SP | 47.0 | 49.6% | 2000
4 | EN | 30.5 | 61.5% | 200000
5 | SP | 10.0 | 57.34% | 8000

After Filter: unselect SP
1 | EN |70.0 |75.3% | 4765
2 | EN | 30.5 | 61.5% | 200000

Started with this formula, but it is not dynamic and only looks at 2 out of 3 criteria
=IF([@Wait]>0, RANK.EQ([@Wait],[Wait])+COUNTIFS([Wait],[@Wait],[Success],">"&[@[Success]]),500).

Any ideas? Hope it's not impossible...

 

[ja4day]

I am also open to other variations of the formula, including use of: countif or sumproduct...