ranking or sorting

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

It worked...thanks so much!

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

 

[Guest]

One more question...

If the NPV's have a name associated with them, is there a way to sort those
as well?