Is it a all possible to reverse positive/negative numbers when using difference from? I have a list of students with a 4 scores (one for each census point). 1 is the best they can achieve and 4 is the worse. Consequently when I do difference from previous score to the next i.e. census point 1 = 4 and census point 2 = 3 the difference should be +1 but is naturally coming out as -1. If I do difference from next the numbers are then correct but ascetically the columns are then in the wrong order! i.e CP1 Difference CP2 Difference CP3..... instead of CP1, CP2 Difference CP3 Difference....Currently I am doing the difference from next and then having to change the columns round when I export into a table. Is there a simple way of doing this so that the numbers are correct and the columns appear as I would like them? I hope I have explained this clearly and apologies if this is a really basic question!
Hi Emma,
Have you tried the ABS function? It will always return a positive value, no matter if the difference is positive or negative: =ABS(A2-A1)
If this is not what you mean, please upload a sample file, it will be easier to understand.
Regards,
Catalin Bombea
Thanks for the response! Since asking the question I have had a little play and have worked out how to achieve what I need. 
