I've never had a problem sorting columns based on formulas.

What happens when you try to sort?
--
Brevity is the soul of wit.


"Redleg24" wrote:

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!