Code to return date multiple criteria

[riiiiiicjjj]

Hi all,

I have no knowledge of VBA whatsoever and there is a function I need that is impossible to get on excel 2016.

attached you can find my data set with 4 columns A to D. the order of the data in these columns will change except from the headers. I would really like to have a code that will generate columns F and G.

column F is a consolidation of all unique numbers (loan ids) from column A (might include text and numbers i.e 1025A).

column G returns a certain date. For each loan id the date would be the last "to be paid" date which represents the cumulative amount of payments that have not been covered untill this date.

For example, loan number 1006 paid at 9 different dates and reached a total of 89,855. By the date 20/09/2021 this loan should have paid 90,000 and this amount has never been covered. the result I need is the date 20/09/2021.

Another example, loan number 1006 paid at 11 different dates and reached a total of 121,000. by the date 10/03/2022 this loan should have paid 141,420 this amount has never been covered. the result I need is the date 10/03/2022.