For this you are going to have to use a dummy column unless you know how to
code with VBA.

Put the formulas in to a column where they won't be changed, and you can
hide them also.

Say you put the formulas in E1 through E5
In A1 through A5 put in these formulas

A1=Large(E1:E5,1)
A2=Large(E1:E5,2)
A3=Large(E1:E5,3)
etc
etc

Large gives you the ability to pick what max value you want out of an array
of numbers.

So whenever the values change this will change with it

"Fernando Ronci" wrote:

Hi,

In Excel 2003, how can I automatically sort a range of cells which hold the
computation of other cells? Let's visualize this by means of an example.

Let's say I manually input some numbers on cells A10 through D14. These
cells are the source.
The computed cells are A1 through A5 whe
A1=A10+B10+C10+D10
A2=A11+B11+C11+D11
A3=A12+B12+C12+D12
A4=A13+B13+C13+D13
A5=A14+B14+C14+D14

Now, I want the sorting of A1..A5 to automatically happen in real time
according to the computed sums. In other words, every time a cell of the
source changes, A1..A5 should be re-sorted. For instance, if the computed
values are A1=10, A2=3, A3=8, A4=12 and A5=7 then I want them to be
displayed like so:
12
10
8
7
3

Can I bind the sorting of A1..A5 with changes in the source cells A10..D14 ?

Thank you.