Even less memory consuming: Highlight A1:A5 and insert my formula in one shot
(press ctrl+shift+enter after inserting).

"Alojz" wrote:

Actually, u will neither need macro, nor dummy cells, u may do it with array
formula. Insert in A1:

=LARGE(($A$10:$A$14+$B$10:$B$14+$C$10:$C$14+$D$10: $D$14),row())

press ctrl+shift+enter, drag and copy down. Thanks to akphidelt pointing on
LARGE formula, the rest was quite easy to solve.

"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.