Hello excel experts, I have come up with the following formula for solving the problem above. Entered at cell H6, and then dragged down. It works perfectly, but I do not like it because it is causing very slow calculation. Would you please bring up an advice/ alternative way of solving this problem? I thank you in advance. I hope someone will help me solve this.
=IF(AND(E6="repayment",TODAY()-INDEX($C$6:$C$1015,MAX(INDEX(($B$6:$B$1015&$D$6:$D$1015=C6&"loan")*MATCH(ROW($B$6:$B$1015),ROW($B$6:$B$1015)),,)))>90,INDEX($G$6:$G$1015,MAX(INDEX(($B$6:$B$1015&$D$6:$D$1015=C6&"repayment")*MATCH(ROW($B$6:$B$1015),ROW($B$6:$B$1015)),,)))>0),H6,"")