I currently have a chart showing the weather (highest and lowest temperature in Celsius) of some cities for 7 days and the average for each day on the right. However, I am required to put the temperatures into ascending order. I am wondering whether it is possible to place the average cells into ascending order (which includes moving the two cells next to it with the average formula).

Excel Help.JPG

Please help this is an important part of my schoolwork.
All help is appreciated,

Bruce C