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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>