Forum Discussion
Dynamically Need to find out minimum value of each row after summation of multiple columns.
Hi I may not be very clear in describing subject. However I will try my best to elaborate issue here. I have to calculate minimum for each week and as we move to next week minimum should be calcul...
I cannot see a good approach using min() in this case, because you are not getting the minimun for that week but the minimun for the all dataset.
Your formulas gives the result the following
=MIN(2,4,4,2,6)
This is the same of the column D. So would be better you just apply the MIN() formula there.
But in any case If you need to apply the formula the way you developed, I suggest you insert a table on existing data so everytime you need to include another row, the formula will be updated automatically