• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ascending sorting problem within cell

Villalobos

Active Member
Hello,

I would like to ask some help regarding ascending sorting within cell. My problem is that the code doesn't sort the "unique" values just the numbers.
Please, see the attached file.

Thanks in advance the reply!
 

Attachments

  • Sample.xlsm
    17 KB · Views: 4
Try changing the line:
myArrayList.Add CDbl(itm)
to:
myArrayList.Add Trim(CStr(itm))
 
Back
Top