F

#### Fernando Ronci

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 where:

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.