View Single Post
  #1   Report Post  
Sylgeox
 
Posts: n/a
Default How do I sort a column of computed variables in EXCEL?

I want to sort a column of character variables which have been computed by a
formula. The formula is VLOOKUP(....._). The standard sort routine does not
work because each cell contains the fomula used to arrive at the variable
rather than the variable itself. Is there a way I can copy the column and
retain the actual entries rather than the formula?