ranking or sorting
 

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.

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.

It worked...thanks so much!


"Peo Sjoblom" wrote:

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.

One more question...

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

"Peo Sjoblom" wrote:

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.