You can create a help column that always will be sorted ascending

=SMALL($A$2:$A$100,ROW()-ROW($B$2)+1)

where the data is in A2:A100, copy down this formula to B100 (assuming you
put it in B2)

for descending replace small with large and copy down

--

Regards,

Peo Sjoblom

"Liz23" wrote in message
...
Is there a way to automatically sort data from highest to lowest?

I have a set of NPV values that will constantly change based on different
inputs and need to know if in the summary they can be automiatically
ranked
and sorted.

Thanks.