Hi, I have searched all morning for anything even remotely similar to what I need, but to no avail.

Basically, I have a group of cells (A1:E5) containing data which needs to stay together. This then continues down the page in a pattern, so (A6:E10), (A11:E15) and so on.

In the data, one cell contains a figure which it needs to be sorted by. (Highest to lowest).

Could anyone help me with a formula which would allow me to do this?
Basically, sorting a group of cells based on the value of one of the cells.

Any help much appreciated.

Thanks, Anthony.