The Problem To Be Solved.
A good friend of mine had found that an Excel spread sheet no longer had a formulae in a particular cell. It had a number there instead. This meant that any changes in other cells associated with the missing formulae had no effect on the result in the TOTAL column. On a regular basis my friend had sensibly made a backup of the spread sheet and now my friend had a great number of them. It was imperative that my friend found out when the formulae had gone missing. My friend was about to conduct a manual search and work through all the backups to find the time when the formulae was last used in the spread sheet. Looking at every backup would have given my friend a lot of work. So I advised using a “Binary Chop” method to make it easy. See Example 4 in particular. Continue reading “Manual Search Using Binary Chop”