On 2002-10-30 10:08, mac_see wrote:
I think therez a kind of misunderstanding here....... Let me restate my question.
I am having the following data
A1=Tom, A2=****, A3=Harry,
B1=100, B2=200, B3=300,
What I want is, I need to sort the names in range D1:D3 and sort their respective values in range E1:E3. As given in the above example, you should put a formula in range E1:E3 in such a way that, 300 will come on top (E1), 200 will come in (E2) and 300 in (E3). I need a second formula in range D1:D3 so that the corresponding name for that value will appear in the respective cell.
In your earlier example, the names were sorting properly but I am getting 1,2,3 instead of 100,200,300 or any value that I put in range B1:B3.