Cell A1 contains Tom, A2 **** and A3 Harry. Cell B1 contains 3 B2 5 and B3 1. Values in Cell B1,B2,B3 are dynamic and changes according to values present in another worksheets. What I want is in D1 D2 D3 and E1 E2 E3 the same values should be copied but will be sorted in decending order as the value in B1 B2 B3 changes.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula required
- Thread starter mac_see
- Start date
Similar threads
- Question
