I 've created a custom function to estimate a factor based on 2 ranges : Well , AllWells ... what it does is it finds the last non empty cell in each column of allwells range and calculate : factor= Well/Sum(last cells in allwells.range) ....
so my problems are :
When i update unrelated...