Hi
Please find herewith a solution. The issue is because after the first formula you were creating a circular reference in the other columns. By inserting an extra column between each of your columns and putting the formula in each blank column avoids the circular reference problem.
I am sure Colin will come up with a more efficient solution.
Hope this helps.
Tony (OTPM)
|