I have a spreadsheet where I would like to sort the results of a certain
column starting at the highest number down to the smallest number, when I do
this using the Z to A button, the last column (which works out a percentage
with a formula I have put in using the cells I wish to sort) gets messed up
and just shows #DIV/0! I think this maybe because it is automatically sorting
the total of the sorted column at the top of the spreadsheet after a sort
instead of the bottom which is in turn messing up where the formula is
looking to work out the percent.
Hope this makes sense and someone can help
Ruth