Comparing Values for Sorting
I pasted in your data:
030613-01 ' in cell A1
030613-01R1 ' in cell A2
030731-01
030811-01R1
030811-02
030814-01
030821-01
030821-02
030821-02R1
030823-01
and in the cell next to each I put in a UDF
Function CompStr(rng As Range, rng1 As Range)
CompStr = StrComp(rng, rng1, vbTextCompare)
End Function
starting in B1 so that the formula in B1 was
=Compstr(A1,A2)
In each case, the formula returned -1 indicating that the value in that row
was less than the value in the next row - so that string compare was/is
returning the same evaluation as the Sort command.
It is unclear how you are using strcomp, but I would suggest your code is
misinterpreting what is returned.
--
Regards,
Tom Ogilvy
Suh, Suk Ho wrote in message
news:rNizjIXaDHA.274@newsgroup...
Dear Colleagues;
How do I sort an array containing the following string values?
I tried using Strcmp function and < comparison to compare each elements,
but the results don't look as I expected. for example if I compare
030814-01
with 030811-02, Strcomp renders a reverse result. But when I paste this
value into a sheet the Sort works ok. So, I'm lost.
Any guidances will be most appreciated.
from this
030814-01
030409-01-R1
030821-01
030731-01
030821-02
030613-01
030613-01R1
030821-02R1
030811-01R1
030823-01
030811-02
to this
030409-01-R1
030613-01
030613-01R1
030731-01
030811-01R1
030811-02
030814-01
030821-01
030821-02
030821-02R1
030823-01
Suk Ho
|