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. Or any other column for that matter. Just hold down the control button and select the entire columns of A, F, and G by pushing 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. You are welcome. See how easy it is to answer a question? Next time don't offer other solutions to a problem and just solve the problem you fascists. If he wanted to sort through a table or pivot chart, he could have found that answer easily anywhere.
Sorry, I wanted to post a screen shot image of this but this website doesn't allow new users to post images. Thanks for making it harder on me webdeveloper. 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. Sorry that it looks all grouped together. This website killed all the spaces when i posted the comment. I typed it to look like columns and rows but this website wants to do whatever the F*ck it wants. I recommend you type this into an excel file. I put a bar like this "|" everywere it's a new column and an astrix like this "*" where there is a new row.
*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?