Topic: To learn the data from cells (date) when reach the intermediate total on set .
The people, help, please, I fight the third day. I understand as should be logically solved, but a functional of formulas Excel it is impossible to solve.
It is given: many suppliers at everyone unique , they pay on different Channels (only 3 channels = 3 columns), kol-in payments (lines) beyond all bounds, are all registers manually in one general table, with in an appropriate column of date of payment.
It is necessary: to learn when the certain total (in an example it is entered manually) on set ID (also in an example is hammered manually) is reached. The intermediate total (which it is compared to the gated in total) should be formed from lines and columns simultaneously, corresponding set (i.e. the total of all elements (payments) two-dimensional array, on set ).
File I apply.