Unexpected results in sorting macro

I have a simple macro that compares two columns and puts new entries from the first column (when compared to the second) in to the 3rd column.

The odd behavior is the last entry in column 3. When I step through the macro, it says Charlie-Brown < Charlie-Brown which it shouldn't be (that's why I sort the columns first). The code I am using appears after the result table below. I've also attached the .xlsm file. I would appreciate any ideas on what is wrong.

Thanks in advance for any pointers!

Alpha	Alpha	Alpha2
Alpha2	Bravo	Bravo2
Bravo	Charlie.Brown	Charlie-Brown
Bravo2	Charlie-Brown
Charlie.Brown	Delta
Charlie-Brown	Echo
Delta	Foxtrot
Echo	Golf
Foxtrot	Hotel
Golf	Indiana

Please Login or Register  to view this content.

How about this "oldie" writen by Tom Ogli? years and years ago.

Please Login or Register  to view this content.

Alf

I know there are several ways to do this. Could you elaborate on your comment that "sorting columns A and B doesn't mean your "less than" will work from row to row." It seems that Charlie.Brown is indeed less that Charlie-Brown if i compare it simply as a formula - i.e. =IF("Charlie.Brown"<"Charlie-Brown","dot","dash") evaluates to yet when the macro runs "Charlie-Brown" < "Charlie-Brown" evaluates to true which throws "Charlie-Brown" out into column 3.

Thanks
ken

Originally Posted by MarvinP

Step through your code watching your Y and Z variables. It is your assumption that going down your list on the right will always be less than the reduced values on the left. It is like a one off problem.

Hi Marvin - thanks for the help. When i step through the debugger, the problem i get is that IF "Charlie-Brown" < "Charlie.Brown" evaluates to TRUE. But it seems like it should evaluate to FALSE.