How should I do it?
try have Names to the left and value to right
then select Names and values and then make ur chart
C56=INDEX($A$56:$A$63,MATCH(D56,$B$56:$B$63,0))
D56=LARGE($B$56:$B$63,ROW()-55)
copy down
By the way if 2 names have same value then the first name showing twise
im trying to find a way to fix this
|