Quote Originally Posted by martindwilson View Post
trouble is col d is calculated and wont sort as it just recalculates whats in the cell a1/b1 but column e does sort with the original values but now has the wrong value next to it
Do you know of anyway to overcome this? Sort based on a calculation?