Incorrect sort

T

tommywildfire

When I select all my data and attempt to sort it (with 3
cirteria), the beginning is sorted fine. Further down, it
is out of numerical sequence based on the sort (did not
sort). This worked fine for months and months until I
added 200 additional rows of the same type of information.
Now, it will not do a complete sort. Example:
1,2,3,4,5,1,6,7,2,3,8,9, and so forth. Any ideas?
 
F

Frank Kabel

Hi
try checking if all values are really numeric values. e.g. enter the
following formula in an adjacent row:
=ISNUMBER(A1)
This should return TRUE for all your numbers
 
Top