Attention all excel experts! I have a bit of a problem that I can't seem to solve regarding sorting. I have been given 2 separate lists with a common column from 2 different people that I am trying to sort so that I can merge them together. The problem is that when I sort the 2 lists based on that column it sorts them both differently... eg:
List 1 List 2
1 1
2 10
3 11
4 12
. .
. .
. .
10 2
11 20
etc... you get the point. The columns are both formatted as numbers but for some reason I can't get that column to sort the same way in the 2 separate lists? What am I doing wrong?
EDIT: Sorry about the formatting above... it looked right as I was typing.
|