Sorting Problem

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I can't seem to sort data in a table where the cells are comprised of
formulas. If I copy and paste the values only to a new table then it
sorts fine.

Is there a way to sort a table where there are formulas? I've tried
ASAP utilities as well.
 
I should note that I tried to sort a table with formulas in a practice
sheet and it worked. However, the formulas were within the table.
The formulas in the table I'm trying to sort are derived from another
part of the spreadsheet--not from within the table itself. If that
matters.
 
Back
Top