Real Arrange VS Alphabetic

[vasc]

Hi my friends...

In my file formula arrange text alphabetical, but my need is real arrange.
I try more formula modification but nothing happend.. (not work, #VALUE!)

Can somebody to change formula for result like J row?

Thanks

[Bo_Ry]

Please try at G2

=IF((ROWS(G$3:G3)>COUNTIFS($B$3:$B$82,$E$3,$C$3:$C$82,""))*(B3=$E$3),INDEX(C:C,SMALL(IF(($B$3:$B$82=$E$3)*($C$3:$C$82>""),ROW($B$3:$B$82)),ROWS(G$3:G3)-COUNTIFS($B$3:$B$82,$E$3,$C$3:$C$82,""))),"")

confirm with CSE

[CARACALLA]

unique list color for spot

select spot with drop down list in e3

G2=IFERROR(INDEX($C$3:$C$100,SMALL(IF(FREQUENCY(IF($B$3:$B$100=$E$3,IF($C$3:$C$100<>"",MATCH($C$3:$C$100,$C$3:$C$100,0))),ROW($C$3:$C$100)-ROW($C$3)+1),ROW($C$3:$C$100)-ROW($C$3)+1),ROWS($C$3:C3))),"")

control+shift+enter
Copy down

[vasc]

both wonderful answers dear friends....