Automatic Sorting

[Dave Clark]

Is there a way to get numbers in a cell range to
automatically sort themselves into order when they are
changed?

Thanks

 

[Bernd Plumhoff]

This is possible with a "help"-sheet. Have a look at
http://www.pulrisk.de/excel-beispiel/efficiency_abalysis.xls

(no guarantee for function or quality given, try at your own risk - but I
created this with all possible care)

Regards,
Bernd Plumhoff

 

[Bernd Plumhoff]

sorry, a typo. correct is
http://www.pulrisk.de/excel-beispiel/efficiency_analysis.xls