Question 1: How do I automatically (without out pressing the sort button) sort data in ascending order? Question 2: Alot of my values will be 0, and therefore if I sort in ascending order, they will stay at the top of the list. How can I automatically sort it, in ascending order, but keep the cells with 0 at the bottom of the column. e.g. in the below example, how do I sort so that Player 1 - 4 remains at the bottom? PLAYER 1. 0 PLAYER 2. 0 PLAYER 3. 0 PLAYER 4. 0 PLAYER 5. 2 PLAYER 6. 10 PLAYER 7. 12 Thanks you very much. Kind Regards Matthew
Solved by K. Y. in 12 mins