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.
Answer suggested by Dave Patton - Board Master is:
in E1 =LARGE($B$1:$B$3,1)
in E2 =LARGE($B$1:$B$3,2)
in E3 =LARGE($B$1:$B$3,3)
in D1
=INDEX($A$1:$A$3,MATCH(E1,$B$1:$B$3,0))
This does not work if I put the same value for two person. For example, if I put 4000 for Tom and 3000 for **** and Harry, the reference D2 and D3 both shows ****'s name and Harry is disappeared???
Answer suggested by Dave Patton - Board Master is:
in E1 =LARGE($B$1:$B$3,1)
in E2 =LARGE($B$1:$B$3,2)
in E3 =LARGE($B$1:$B$3,3)
in D1
=INDEX($A$1:$A$3,MATCH(E1,$B$1:$B$3,0))
This does not work if I put the same value for two person. For example, if I put 4000 for Tom and 3000 for **** and Harry, the reference D2 and D3 both shows ****'s name and Harry is disappeared???