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
Bookmarks