Sorting results not what I want

  • Thread starter Thread starter emile
  • Start date Start date
E

emile

I am sorting a range by an amount (formatted as a number).
The amount is the result of a formula G6=IF(ISBLANK(H6),"",H6*I6). I used
ISBLANK to get rid of any error msg because other cells are blank.
When I sort the the range (A6:N105) by descending amount using the G column,
the results are correct but appear at the bottom of the range. When I sort
ascending the results are correct and appear at the top of the range
How do I get the descending sort to appear at the top of the range?
 
You should never sort on a formula field. What the formula displays depends
on the values in two other cells. So when you sort the data the results in G
will change.

You might convert the formulas to values (Copy the range of G cells, with
the range still selected, used Edit | Paste Special with Values specified)
best wishes
 
Back
Top