View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Redleg24 Redleg24 is offline
external usenet poster
 
Posts: 3
Default I can't sort data when the key column cells contain formula

I am not able to sort a range of data where the "key" column conains ONLY
formula. While the computer screen displays the numerical result of the
formula in each cell of the column, the excel programming apparently can't
"read" the cell contents as a number in order to rearrange the rows in
ascending or decending order.

I'm an experienced excel user, however I've got a sneaking feeling that I'm
missing something a beginner could figure out!