Hi there,
I would like to find the largest and smallest number by doing multiple calculation in a range of data.
Suppose
There are four range A2:A50, B2:B50, C2:C50, D2:50
what I would like to do it
(D2-B2)-(C2+A2)
(D2-B3)-(C2+A3)
(D2-B4)-(C2+A4)
(D2-B5)-(C2+A5)
(D2-B6)-(C2+A6)
(D2-B7)-(C2+A7) and so on..... and at last find the largest of this 50 calculation and put it in cell F2
here, I have attached the file and written all the information about what to do in it....
if any one can help me.
Bookmarks