Can someone please help me understand the logic for Sorting in Excel?
I have a column with Policy ID with 12 characters. The last three characters are just the sequence so they are not necessary when I am looking for unique IDs. I use the left function to pull the first 9 characters in a different cells. So when I sort the two columns I get different results based on which column I am applying the sort criteria.
Here are my results:
This seems to me that Excel is looking at the characters from left to right when doing the sort. Is this a correct assumption? I am getting two different results.
Thoughts? Comments?
Thanks in advance.
I have a column with Policy ID with 12 characters. The last three characters are just the sequence so they are not necessary when I am looking for unique IDs. I use the left function to pull the first 9 characters in a different cells. So when I sort the two columns I get different results based on which column I am applying the sort criteria.
Here are my results:
This seems to me that Excel is looking at the characters from left to right when doing the sort. Is this a correct assumption? I am getting two different results.
Thoughts? Comments?
Thanks in advance.