A worksheet of employee data is only 5 columns, and only one of those
columns, Length of Service, is data that is the result of a formula. That
formula subtracts the hire date from current date and shows number of days of
service. All the other data in the other columns is hard data. I wish to sort
by the Length of Service. When I click a cell in the Length column then click
AZ, about half the cells change to #REF!. When I click ZA, about 2/3 change
to #REF! and one changes to #####. I have accomplished the desired sort by
manually copying the results to another column and sorting by that column of
Hard data. It leads me to beleive that Excell can only sort Hard data. Or is
it possible to sort a column by the resultants of formulas? All ideas,
suggestions, and comments will be greatly appreciated. Thanks, K.