This is how you sort data dynamically. The first one shows the results while the second one shows the equation used. Don't worry about the "C" Column being a bunch of random numbers. That's just the date converter that you don't have to understand. It's like computer formula for the date or something. Anyways the VLookups are all pretty much the same so it's easy. Rank column needs to be the far most left column. Since you put 0009 and all those other crazy numbers, I had to write them in as text rather than numbers. Because of this, I couldn't use rank to order them. So I created column "F" to convert the text 0009 to just 9 in number format. I used the Value function to do that. That pretty much covers it. Now you can hide columns A, F, and G if you don't want to see them. Just hold down the control button and select the entire columns of A, F, and G by clicking on the actual letters A, F, and G on the column labels. Then just right click one of those columns and find where it says hide.
Sorry, I wanted to post a screen shot image of this but this website doesn't allow new users to post images. Here is the output table. I skipped the other columns because they would take up too much space on this website and they are almost exactly the same as columns G and H, so it shouldn't be that hard for you to figure it out.
A| B| C| D| E| F| G| H| I|
Rank| Tasks| Date| H-L| w-text| w-num| FinRank| VLookup| VLookup|
4| Task 01| 6/19/2013| Low| 0009| 9| 1| Task 04| 6/19/2013|
2| Task 02| 6/20/2013| High| 0999| 999| 2| Task 02| 6/20/2013|
3| Task 03| 6/30/2013| Med| 0089| 89| 3| Task 03| 6/30/2013|
1| Task 04| 6/19/2013| High| 1000| 1000| 4| Task 01| 6/19/2013|
Here is the formulas
Column A, where it says 4: =RANK(F2,$F$2:$F$5,0)
Column A, where it says 2: =RANK(F3,$F$2:$F$5,0)
and so on and so forth...
Columns B, C, D, and E are just text you input.
Column F, where the 9 is: =VALUE(E2)
Column F, where the 999 is: =VALUE(E3)
and so on and so forth
Column G, is just numbers from 1 to whatever number you want. You just type them in. You need this to do the VLookup.
Column H, first row: =VLOOKUP(G2,$A$2:$F$5,2,FALSE)
Column H, second row: =VLOOKUP(G3,$A$2:$F$5,2,FALSE)
and so on and so forth...
The rest of the columns are just like column H.
Column I row 1 looks like this: =VLOOKUP(G2,$A$2:$F$5,3,FALSE)
Column J row 1 looks like this: =VLOOKUP(G2,$A$2:$F$5,4,FALSE)
Column K row 1 looks like this: =VLOOKUP(G2,$A$2:$F$5,5,FALSE)
*See how there is only 1 difference between them? Easy right?
1If this info is in a table just use the filter dropdown to sort by your weighting field, once that's been done once you just just hit the dropdown to filter and hit done, which would be a lot less work than creating a whole second sheet, and is far more reliable – CLockeWork – 2013-06-19T13:45:12.050