I would like to take a list of names and values and have the list recreated on another sheet in descending order according to the value.
As an example:
(This list would be limited to 12 names/values)
A B
Smith 35.00
Jones 1.00
Davis 45.00
Desired result:
Davis 45.00
Smith 35.00
Jones 1.00
The best I have been able to do to this point, is get the numbers ranked using the BIG formula. I do not know how to assign the corresponding name to those values. Also, FWIW, many of the values may end up being identicle.
I need this to continue to update as the names are added to the list. The names my be added in any order from 1-12. In other words, the first name may be added to the 9th spot with a value of 2.00. (At this time, the ranked list should show this name in the first spot) The next name may be entered in the 3rd spot with a value of 70.00. (Now the list should have this name in the first spot and the previous in the second spot...)
I hope this is clear...I am trying to be as detailed as possible. I apprecaite any help.
Thanks,
Mark
As an example:
(This list would be limited to 12 names/values)
A B
Smith 35.00
Jones 1.00
Davis 45.00
Desired result:
Davis 45.00
Smith 35.00
Jones 1.00
The best I have been able to do to this point, is get the numbers ranked using the BIG formula. I do not know how to assign the corresponding name to those values. Also, FWIW, many of the values may end up being identicle.
I need this to continue to update as the names are added to the list. The names my be added in any order from 1-12. In other words, the first name may be added to the 9th spot with a value of 2.00. (At this time, the ranked list should show this name in the first spot) The next name may be entered in the 3rd spot with a value of 70.00. (Now the list should have this name in the first spot and the previous in the second spot...)
I hope this is clear...I am trying to be as detailed as possible. I apprecaite any help.
Thanks,
Mark
