Hello.
5tw66q.jpg
I would like to sort the data in the LINK/PICTURE into numerical order (largest to smallest) by column O. But when I try to sort Manchester City and Manchester United by the figure in Column O, it places Manchester City into 'O2' and Manchester United into place 'O3', messing up the formulas.
I need to sort the data while keeping or locking A2 to 02 and A3 to O3 together for Manchester United for example so that the formulas don't miscalculate. I don't know how to do this.
Sorry if I explained it badly, I've only been using excel for a month. Please can anyone help? Thanks and Happy Christmas (:
Bookmarks