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