I have two columns. Column A has various numeric values. Column B, has the position of the numbers in Column A. I want to use a formula to sort the numeric values in column A, (largest to smallest) and have the corresponding position of those numbers, in column B. Example:




START END RESULT
VALUE POSITION VALUE POSITION
4 1 6 4
1 2 5 12
3 3 4 1
6 4 4 6
3 5 4 8
4 6 4 10
3 7 4 15
4 8 3 3
3 9 3 5
4 10 3 7
3 11 3 9
5 12 3 11
3 13 3 13
3 14 3 14
4 15 3 16
3 16 1 2




I know I could use the simple sort function in Excel 2007, but I have over a hundred of these sets of columns. Takes way to long to sort each individually.

Would prefer a formula rather than a macro, as I have never used a macro's.

Any help would be greatly appreciated.