V Villalobos Active Member Jul 3, 2014 #1 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 Sample.xlsm 17 KB · Views: 4
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!
Hui Excel Ninja Staff member Jul 4, 2014 #2 Try changing the line: myArrayList.Add CDbl(itm) to: myArrayList.Add Trim(CStr(itm))
V Villalobos Active Member Jul 4, 2014 #3 Hello Hui, Let me to say thank you for the help! Your advice working well!