I have two columns with auto mileage numbers. Each has a different set of numbers. We have not been sorting on column G. I've been sorting column H highest mileage to lowest.
This works perfectly, for example:
Column H after sort
But if I change the letter "h" to "g" in the code the sort puts a particular number in the top cell, the same number every time. The rest of the numbers under it appear to have sorted properly.
Column G after sort
Code that works:
Code that doesn't work:
I've tried changing the formatting and checked to make sure the number that keeps coming up at the top doesn't have a single quote , but I am really stumped. I'd appreciate any help you can give me. I need to wrap this project up as soon as I can. Thanks!