Dear friend,

Here is a code for me to print the names in ascending order even if values are of same means it is showing one name only instead of the other name


means if values are A=1 B=2 C=3 D=4 E=2

it has to show like this A B E C D

But the result is coming like this A B B C D

Please help me out how to solve it

Formula which i used
=OFFSET(B$6,MATCH(SMALL(C$6:C$18,ROW()-ROW(C$6)+1),C$6:C$18,0)-1,0)test.xls
Here i am attaching the sample file for your reference