If you want the rank within the filtered data (70 or so)
use this formula in MyOrder:
=(SUMPRODUCT((MyDataMyData 2:2)*
(1/COUNTIF(MyData,MyData)))+1)/COUNTIF(MyData,MyData 2:2)
This assumes MyData is a single column, starting at row 2.
Copy the formula down as far as needed. This is not an array formula.
I suggest you troubleshoot the problem/procedure with a very short
and simplified list that fits on one page.
When you name a range, verify it by clicking on the appropriate
name in the name box or go to
Insert Name Define
You don't have to use names, it just makes the formula
more readable and it's appearance location independent.